Re: Transferring Large Amount of Data from Excel 2003 to Access 2003

Thanks. I am gong to try this right now. Is this the fasted way (in
terms of performance) to get large amounts of data from Excel into
Access?
Klatuu wrote:
The only thing lost was if you install SP2, you cannot update data in a
linked Excel spread***. Here is the sequence of events to do what you
want. For specifics on each method, see Help in the VBA editor:

1. Link to the spread*** using the TransferSpread***
2. Create an Append query that appends the data in the spread*** to your
existing table. No looping should be required.
3. Use the DeleteObject method to destroy the link to the spread***.
--
Dave Hargis, Microsoft Access MVP


"SSweez@xxxxxxxxx" wrote:

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



.