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 |
|
footohi
Starting Member
10 Posts |
 Posted - 2006-06-07 : 19:37:48
|
| 1st: I'm wondering if anyone has done this?2nd: Some thought on the best way to do this?I need to upload a query from our MS Access database to Data Warehouse database.In DTS I made a connection to Access db, but can't make one to DW.I've done this before uploading SQL to DW using a Linked server. |
|
|
vl262610
Starting Member
6 Posts |
Posted - 2006-06-13 : 13:58:33
|
| 1. Consider making an odbc connection on your access system2. Create a table in access which has to be uploaded3. use upsizing wizard in access to add table to SQL |
 |
|
|
|
|
|
pump data from MS Access to DW