How to use VBA retrieve data from Excel to Access

  • Thread starter Thread starter Paul
  • Start date Start date
P

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?
 
Back
Top