Importing Excel Data

[r7stevens]

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?

 

[Klatuu]

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.