Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blondie317
Starting Member
1 Post |
 Posted - 2010-04-14 : 18:22:51
|
| I am working on an ACCESS GUI linking to a SQL Server database. I need to bring in data from another SQL Server database and an ACCESS database, but have no clue how to do this at the same time. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-14 : 18:31:24
|
| Are you importing the data into SQL Server, or Access? Do you need to copy the data to the destination, or just reference it? You can create linked tables in access to SQL Server tables and other access databases. This doesn't copy the data into your database, but does allow you to use it as you would normal access tables. Is that what you're trying to do?------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
|
|
|
Importing data from Mulitple data sources at once