Importing a file name

[angelinarose via AccessMonster.com]

Hi Folks,
I current have a database set up to look up file name of an excel spreadsheet
and import it into the database. Each day we receive a excel spreadsheet with
blah20080416.xls
The importing of the file works fine but I was wondering if there is a way to
capture the date out of the file name and place it into each record that is
import from the spreadsheet?


any help would be greatly appreciated
thanks!

 

[Jeanette Cunningham]

angelinarose,
In your code, you can save the name of the workbook as a string variable
called strTheFileName.
strPartFileName = Left$(strTheFileName, Len(strTheFileName) -4) will give
the file name without the .xls on the end.
Right$(strPartFileName, 8) will give you the date as 20080416.
You can run an update query to set the date field to 20080416.


Jeanette Cunningham