Import Text file Name into Access

  • Thread starter Thread starter jon.ingram
  • Start date Start date
J

jon.ingram

Here is what I am looking for:

Sample:

I have these files in a directory
- Nov 2008 Sales.txt
- Oct 2008 Sales.txt
- etc.

I have written a vba loop to import all these files into a single
table however if I need seriatim data by month the fields in the file
do not have the dates so I was wondering if any one knew of a way to
insert a field that reflects the file name.

Thanks in Advance.
 
Post your code so that we can see how you're doing the import. How you're
doing it will dictate suggested solutions to your question.
 
Back
Top