Reading a text file

D

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

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

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