Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: IMPORT and PROCESS HELP

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: IMPORT and PROCESS HELP

    Originally posted by hys
    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
    Hello Hys,

    link the excel file as a table in your production database file and run the update query on it

    hope this helps
    qha_vn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •