Saving OLE Excel to Access table

[cbh35711]

All Hello,

I have an embedded Excel 2007 file on an Access 2007 form. The excel file provides the user interface i need easier than recreating it in Access. Once the user has input the required information, I need the data to be saved in a table.

I have worked with recordsets before, but not exactly sure how to handle this one.

Alternatively, I could save it to their computer then import it back. This seems like a roundabout way to do it, but i think it would work.

Any advice would be appreciated!

Thanks!

Chris

 

[Fuse3k]

If you know the path to the actual Excel File you may be able to do something like this :

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TABLENAME", "C:\pathttofile\excelfile.xlsx"