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)

wrote in message
oups.com...
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