msoFileDialogFilePicker read multiple files into seperate tables

[gammaman]

I am trying to use msoFileDialogFilePicker to select 2 excel files. I want to open each file and read the first row of the file into its own access table. It works fine for one file but when I have 2 files it only reads data from the one file.

Please Login or Register  to view this content.

[Norie]

Why are you opening the files in Excel?

Couldn't you just import them to temporary tables using TransferSpreadsheet?

Then you could run append queries to add data from the temporary files to the tables you've created.