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

 

[SSweez]

I just want to clarify that I need to do this from Excel as this is the
front-end. Thanks.

 

[Bill Voorhees]

Could you do the following:
* set up an access table to contain the records in excel
* save as csv file
* create a header row for your excel table with column names identical to
your field names in access.
* In access, open your mdb file, choose -get external data- and choose to
import the csv file into your access table.