Import daily updated excel into Access 2002-2003

[phildcs]

Hello All,

I am trying to find a way to import an excel file into an access database. My problem is that the file I need is the result of a query that is generated by an oracle product. The name of the excel file changes daily as the query changes daily. I was wondering if there was a way to create a macro that looks for a file in a shared folder that contains "%constanttitle" or some command that only imports the most recent file?

I have found some coding but nothing that applies specifically.



Thanks,
Phil

[June7]

Not a macro but VBA code can examine the names of each file in a folder.

Google: Access VBA list files in a folder

http://www.allenbrowne.com/ser-59.html

[phildcs]

Thank you for the assistance, but will this help for a file that has its name changed every day?

[June7]

You said you want to look for a file that contains a specific string. There must be some consistency for conditional code, even if it is to import every file in specified folder that has .xlsx extension.

[phildcs]

True! Thanks for the help.