Is there code to import an excel file to the back end database?

I have QC.mdb and QC_be.mdb. I want to have the user click a button on the front end QC.mdb switchboard and import the excel data into a QC_be.mdb table. (I'm trying to keep the user out of the back end database.)

Can I modify the following line to do this?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
    "tblImportData", "C:\Q_C\Sample_Data.xls"

I use ADO and pass the spreadsheet in a record at a time (with a persistent connection and recordset) and this allows me to send the data anywhere I want. I am not sure if the IMPORT is going to work when you are not importing it to the file running the code.

Alternatively, you can connect the back end table to the front end and import it that way. I think that will work.

Or import it to the front end, and then pass it to the back end using ADO. Many options. But not yours.

Did any of that help?


mmcdonal