Import from EXCEL 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

 

[PassingBy]

Sounds like you just need to create an Append query on your Temp table and add it to where it needs to be.

Create your query and selection criteria then in your code after the spreadsheet transfer run the query by

DoCmd.OpenQuery "queryName"

You would probably wish to also turn off and on the Warnings messages before and after this action.

Hope this helps

Passingby