Appending text files

  • Thread starter Thread starter Ulhas Rao
  • Start date Start date
U

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.
 
-----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
Click to expand...
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
 
Back
Top