Importing Headers from excel.

[joeythelips]

Same problem as before:
"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)."


Craig,

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.
I hope this is of some use!

Joe

 

[Craig0201]

Joe,

But does the header have a specific format? i.e. is it related to the date or is it sequential. If we can judge this, then we can see if we can make a function for it. Give me a few examples for the past few days.

Craig