HI,
I want to import csv file with more than 600,000 records. I usually import it thru import wizard. Is there any other way to import it faster?
HI,
I want to import csv file with more than 600,000 records. I usually import it thru import wizard. Is there any other way to import it faster?
define 'faster'Originally Posted by sai_golden
It usually takes 45 Minutes to upload the file. I tried opening it as a link file but some of the data appears junked like "######" for dates etc.
(a) Is there any way to write a code in VBA to detect the datatype and import
(b) Is there any way to reduce the duration of import.
Thanks
Originally Posted by sai_golden
for (a) - YES - use schema.iniOriginally Posted by sai_golden
for (b) -hard to say, normally [in my experience] any slowdown is due to date-type translation, and for real importing, like in your instance, the Wizard probably sucks. Today I uploaded 1/4 million rows to SQL Server in under 2 seconds using ADO and OpenDataSource(). So I would recommend ADO.
.02 Stan
Thanks Stanl
It should not take that long using VBA code.
I have posted various Import routines for importing on this forum
This is one
http://www.vbaexpress.com/forum/show...ds-into-Access