importing into access

[joeythelips]

I have an access database with a table that imports 200-300 records daily from an excel spreadsheet.
Now the excel spreadsheet has a header that is only visible in print preview. I need to import that header with the excel file i.e i want the header to appear as a field in a reference table.
I will be repeating this action every day, but the header will change every day( it actually contains the excel file's sequence number).

The header comes in an excel attachment I receive by email from an outside source.
I presume they've created it by On the View menu, clicking Header and Footer.Then they Click Custom Header.
The header changes with every new attachment, so I presume they change it manually every day.
Can somone please help?

 

[Databaseguy]

You can't do it with the import wizard. You'll have to do it with VBA code.

If you want some samples, I could help.