Reading a text file

[dhstein]

I'm reading a file each day to update the database. Right now I rename the
file from sales_mtd_06-06-2009.txt to DailyUpdates.txt which I have as a
linked table. But I'd like to skip that step and link directly - or find
some other approach. Any suggestions on a good way to do this ? Thanks for
any help.

 

[John W. Vinson]

I'm reading a file each day to update the database. Right now I rename the
file from sales_mtd_06-06-2009.txt to DailyUpdates.txt which I have as a
linked table. But I'd like to skip that step and link directly - or find
some other approach. Any suggestions on a good way to do this ? Thanks for
any help.

Take a look at the VBA help for the function Dir() and for the TransferText()
method.