Import from Excel - columns / rows

[Mary]

I have a messy spreadsheet I'd like to import on a regular basis. I can't
control the format, it's coming from another office. Will I need to reformat
the spreadsheet before importing, or is there a way for Access to recocgnize
field names and pull the data in the cell to the right of the field name?

Some of the field names are in merged cells in col a & b with data in col c.
Some fields have field name col a with data in col b.
Other fields have field name col c with data in col d.

I know it may not be possible without doing some cleanup on the spreadsheet
first, but thought I'd ask.

Thanks!
Mary

 

[Ken Snell MVP]

ACCESS will not natively import from the format that you describe. You'll
either need to revise the spreadsheet's data before importing, or use
Automation to read the EXCEL file into a recordset that is bound to the
table into which the data are to be imported.