Importing a header from excel 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 every record for that file in the access 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.
If anyone has any ideas please drop me a line. I'd be very grateful.

 

[DougP]

I don't know how to get it automatically. But if you create an update query you can add it to all of the new created records. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Telsa]

If you create a procedure to import into your database, the Excel property for the header is pagesetup.centerheader.

I don't have my book handy, but you need to get the VBA for Excel book so you know how to key in the properties correctly. Mary

Rule 1: Don't sweat the small stuff.
Rule 2: EVERYTHING is small stuff!! X-)