swati
September 13th, 1999, 04:41 PM
Urgent!!
How can I import mutiple excel files to Access 97 database. Do I need to use VBA code?
These excel spreadsheets are used only once to update data in access table. Would like to create an option window like "Open Window" in Windows to be able to select the file I want to import.
I have tried TransferSpreadsheet option to import data but it works only for one file. Is it possible to specify parameter to accept the specific .xls that I want to import?
A Sample code would be appreciated. Thanks for your help.
swati
How can I import mutiple excel files to Access 97 database. Do I need to use VBA code?
These excel spreadsheets are used only once to update data in access table. Would like to create an option window like "Open Window" in Windows to be able to select the file I want to import.
I have tried TransferSpreadsheet option to import data but it works only for one file. Is it possible to specify parameter to accept the specific .xls that I want to import?
A Sample code would be appreciated. Thanks for your help.
swati