Reading a text file

  • Thread starter Thread starter dhstein
  • Start date Start date
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.
 
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.
 
Back
Top