D
dbain30
I have a query to import and export a file into Excel. It is received
each day with the name of the file and the current date in the title
and it also needs to be exported in the same fashion. Is there an easy
way to include this in the programming?
For example, the file for today is listed on the shared drive as
"Customer File 101906.xls" and tomorrow it will be "Customer File
102006.xls" and I'd like to have Access recognize this and
systematically import the data without having to do so manually because
of the date issue.
At the same time, I'd like to export the file as "Customer Information
101906.xls" out of Access without having to type that in myself.
Thanks in advance for any help that you can provide!
each day with the name of the file and the current date in the title
and it also needs to be exported in the same fashion. Is there an easy
way to include this in the programming?
For example, the file for today is listed on the shared drive as
"Customer File 101906.xls" and tomorrow it will be "Customer File
102006.xls" and I'd like to have Access recognize this and
systematically import the data without having to do so manually because
of the date issue.
At the same time, I'd like to export the file as "Customer Information
101906.xls" out of Access without having to type that in myself.
Thanks in advance for any help that you can provide!