How to Append Table with file and add a field with file name

[Mary]

I am appending an Excel Sheet to a table in Access. There are many files to
Import in and I would like the file name to go into a field of each record
appending in because the file name contains a date. I need this date to
reference the detail of the record. How do I get an import script that adds
the file name to that field in each record being appended in?

 

[PieterLinden via AccessMonster.com]

I am appending an Excel Sheet to a table in Access. There are many files to
Import in and I would like the file name to go into a field of each record
appending in because the file name contains a date. I need this date to
reference the detail of the record. How do I get an import script that adds
the file name to that field in each record being appended in?

How are you doing the import? If you're using TransferSpreadsheet, then you
might have to update the table with the filename after the import. If you're
using an append query, you could create a function that returned the name of
the Excel file and then use that in your query...

 

[PieterLinden via AccessMonster.com]

I am appending an Excel Sheet to a table in Access. There are many files to
Import in and I would like the file name to go into a field of each record
appending in because the file name contains a date. I need this date to
reference the detail of the record. How do I get an import script that adds
the file name to that field in each record being appended in?

How are you doing the import? If you're using TransferSpreadsheet, then you
might have to update the table with the filename after the import. If you're
using an append query, you could create a function that returned the name of
the Excel file and then use that in your query...