Importing Excel Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import data into an Access table from an Excel sheet. But the Excel
data is not in typical database format. I have values in C5 and C7 and C10 of
the Excel sheet which need to be imported as a single database record. How
can I do this?
 
You will have to become familiar with automation. Basically, that is opening
a spreadsheet as an Excel object in Access, retrieve the values you need from
those cells, and update the record with that data.
 
Back
Top