D
dhstein
I get a file of sales information every day named Sales-2009-07-14 (today's
date). In a process outside of Access I rename the file to "TodaySales"
Access has a linked text table to "TodaySales" so I can read records from the
file. This is working fine. However, I would like to eliminate the middle
step and have Access read the data directly from Sales-2009-07-14. I believe
I can't link the file since the name changes every day - but maybe that can
be done with VBA (this whole process is automated except for this middle
step). Can anyone suggest how I can do that? Thanks for any help on this.
date). In a process outside of Access I rename the file to "TodaySales"
Access has a linked text table to "TodaySales" so I can read records from the
file. This is working fine. However, I would like to eliminate the middle
step and have Access read the data directly from Sales-2009-07-14. I believe
I can't link the file since the name changes every day - but maybe that can
be done with VBA (this whole process is automated except for this middle
step). Can anyone suggest how I can do that? Thanks for any help on this.