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 |
|
mattbruce
Starting Member
4 Posts |
 Posted - 2001-05-11 : 06:07:52
|
| Does anyone know whether there is a way to quickly insert multiple rows into a MS Access table from a file?The scenario is that we have sent out a Access database to our clients which periodically needs updating with new records. However, we'll be needing to insert around 450,000 records on each update, so need a way of doing this quickly.The file we send them needs to be able to be created from SQL Server 7.Any help would be really helpful. |
|
|
|
|
|
Bulk Copy/Bulk Insert to Access from a file