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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2008-06-09 : 16:25:57
|
| Every month, a huge data need to upload from a Access table to a SQL server table.If I use odbc to do it will cause a heavy network traffic.What is the best way to do it? |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-06-09 : 16:45:54
|
| oleDb driver should provide better performance.Other option I can think of is to expert as cvs/txt into a network drive, and use sql DTS/SSIS to bring it in. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-09 : 22:54:31
|
| DTS/SSIS can transfer data from/to access directly. |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-06-09 : 23:11:25
|
| I prefer creating a linked server to access. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-10 : 01:43:55
|
| You can use OPENROWSET alsohttp://msdn.microsoft.com/en-us/library/ms190312.aspx |
|
|
|
|
|
|
The best way to upload data from Access to SQL