Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MsAccess+Sql Server

 
Thameem Aliyar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a ms access database and sql server database. I need to map the elements of both table and need to retrieve some data. What should i do for.........
Kindly reply me a solution.

Thanking you in advance.............`
 
Vijitha Kumara
Bartender
Pie
Posts: 3930
21
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you trying to do this as part of an application? Or an admin task?
 
Thameem Aliyar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply..
I would like to do it as a part of an application..........

Jindly tell me the solution...........
 
Thameem Aliyar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply..
I would like to do it as a part of an application..........

kindly tell me the solution...........
 
Vijitha Kumara
Bartender
Pie
Posts: 3930
21
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No need to post another reply just to change a mistake, just edit the one you just posted to correct it.

What kind of goal you have to achieve here? What kind of mapping are you talking about? You may need to tell more details about it (TellTheDetails).
 
Thameem Aliyar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for the reply..........

I got the answer..........
I did it using Linked tables.....

Hope similar cooperation in the future........
Thanking you in advance.......
 
Vijitha Kumara
Bartender
Pie
Posts: 3930
21
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you like you may post some tips on how to do it for future readers' benefit .
 
Thameem Aliyar
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Select the linked tables from file..... Add the particular sql server dsn from the machine datasource... And then you can add list of tables from the particular database.......... So it will get attached in your ms access DB.........
Thanks........
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic