Automating the import file(s)

[Guest]

My database is used for “importing†Excel reports, then running the “Find
Duplicate Query Wizardâ€. I was told I can automate the import of excel
files. I know how to "get external data", I built a macro but that pulls one
file at a time. I need the users to be able to go to a folder and then pick
which file they want. I need to build a form that will allow users to import
the file to a table. Then I can run the find duplicates.
I have tried a number of things, but it tells me file in use. Any
suggestions?
Thanks

 

[Guest]

First, you need the code to implement the Open File dialog. You can find it
at this site: http://www.mvps.org/access/api/api0001.htm

There is an example in the code that will show you how to use it. It will
return a complete path and file name which you can then use in your
TransferSpreadsheet.