Import Excel - add sheetname as a record in access

[ma143hal]

Hello!

I have to import excel spreadsheets with multiple tab/sheet names which changes all the time. The tab/sheet name is the invoice number so I need to add the invoice number as a record in the Access table for reporting purposes.

I know how to display the sheet name using vba code in Excel itself. I'm not really sure how to go about this via import into access.

Your help is greatly appreciated.

Thanks.

 

[gromit]

Here is a link that I found very helpful in designing an import routine:

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=377419&Main=377419

hth,

-g