I'm in Access, and I've to develop and application that import data from an Excel SpreadSheet and copy such data into an Access table.
I've used the following code to open the Excel Spreadsheet:
Dim xl As Object
Set xl = CreateObject("Excel.Application")
xl.Workbooks.Open "D:/Foglio.xls"
and it works....
now, how can I open the CurrentDb in other to copy data
into a speific table ? I've tryed with ADoRecordset
but it fire a runtime error for the following instruction:
Dim myRec As AdoRecordset
Can someone help me ?
Thanks a lot.
I've used the following code to open the Excel Spreadsheet:
Dim xl As Object
Set xl = CreateObject("Excel.Application")
xl.Workbooks.Open "D:/Foglio.xls"
and it works....
now, how can I open the CurrentDb in other to copy data
into a speific table ? I've tryed with ADoRecordset
but it fire a runtime error for the following instruction:
Dim myRec As AdoRecordset
Can someone help me ?
Thanks a lot.