Transferring Large Amount of Data from Excel 2003 to Access 2003

[SSweez]

I have about 1,000 to 1,500 records in Excle 2003 that I am trying to
get into Access 2003 using VBA the fasted way possible. Right now I
have an INSERT query that loops through the records but this is very
slow. I have read about some other options that would be faster like
creating a linked table to this data and then I can append the data and
destroy the linked table. However, I think this functionality was lost
in Excel 2003 but I am not sure. Can anyone help with what the best
solution is and some sample code (or a reference on the web I can get
to). Thanks in advance.

-Scott

 

[Chip Pearson]

Probably the fastest way is with the CopyFromRecordset method of a range.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[SSweez]

Thanks for your response. I have come accross this method but I
thought this could only be used when getting data from Access to Excel.
In my case I need to get a large amount of data from Excel into
Access. If I can use it in this direction can you help me out with
some example code. Thanks so much.

-Scott

 

[Chip Pearson]

No, you can't use CopyFromRecordSet in the other direction. I misread your
question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)