How to use VBA retrieve data from Excel to Access

[Paul]

I have an excel table and access database. Everytime I get errors when I try
to import the excel table into the Access. So I decided to use VBA to do it,
but I don't know how to write the codes in the Access file to control the
excel data. For example, how can I let my Access VBA code read data from the
other excel file?

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/modules/mdl0006.htm at "The Access
Web" is enough to get you going.