Thread: What to do with 1.5 million records...
View Single Post
  #3  
Old April 14th, 2010, 03:29 PM posted to microsoft.public.access.tablesdbdesign
Stefan Hoffmann
external usenet poster
  
Posts: 991
Default What to do with 1.5 million records...
hi,

On 14.04.2010 16:25, Stefan Hoffmann wrote:
While Access can handle huge amounts of data like this, I would use a
SQL Server back-end and use the BULK INSERT command to load the data at
once.

http://msdn.microsoft.com/en-us/library/ms188365.aspx


mfG
-- stefan --