import from EXCEL to ACCESS, HELP !!!

[hysaccess]

Hello all

Oh, here's the deal I have information in Microsoft Excel, which I need to process and append to the access database.

So I first import the data from excel to access on a temporary table using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp", strRet, False, "Sheet1!A2:N65536"

Having done that now i need to cycle through each record in the temporary table and send it into the production database with those who satisfy my SQL statement ...

I need all this to be done programmatically... HELP

 

[AgatheB]

Hi Hysaccess,

Why don't you just cycle through your excelfile and do all checking there and if the record is satisfactory send it to Access with .addnew and .update?
So without using your temporary table....

 

[ETID]

Have you tried to link to this .xls from within access...

File>Get external data>link tables...

choose msexcel from files of type...follow the wizard from there.


that way you can use the spreadsheet as though it were a table.