Import Text file Name into Access

[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.

 

[Ken Snell \(MVP\)]

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.