Appending text files

[Ulhas Rao]

I receive text files (in csv format) daily and the format
of the file is NOTyyyymmddxxxxxx.txt
I need to import these files into Access and append them
to a table called Notifications. The columns are fixed and
will either have data or blank space.
Since the file name changes everyday, I cannot write a
macro to import.

 

[larry]

-----Original Message-----
I receive text files (in csv format) daily and the format
of the file is NOTyyyymmddxxxxxx.txt
I need to import these files into Access and append them
to a table called Notifications. The columns are fixed and
will either have data or blank space.
Since the file name changes everyday, I cannot write a
macro to import.

.
I have the same problem as I import tickets monthy and

each day the daily.txt is a different name.
I have a batch file in dos linked to my desktop that
combines all the daily files into one file called
tickets.txt. Then I link the ticket.txt file to access.
When finished I clear out the ticket.txt table for the
next month.

copy *.txt tickets.txt
exit