Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access from Excel (Office 2003)

    I'm using DAO to manipulate an Access Table. I'm using the RecordSet AddNew method to add a new record to the table based on an Excel row of data.
    What would be the best (most efficient) way to append an Excel list of data to an existing table? Is there a way that I can treat the list as though it were a table and then run an Append Query using the Execute method? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access from Excel (Office 2003)

    If the Excel data are in a recognizable table format, you can create a link to the Excel table in your database, either manually, or using DoCmd.TransferSpreadsheet in code. You can then create an append query based on the linked table.

    Using ADO you could open a recordset on the Excel file.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access from Excel (Office 2003)

    That's the way I got round the issue - using DoComd.TransferSpreadsheet. I was hoping there was some way to treat the Excel list as though it were a table. Can you provide more details on your statement 'Using ADO you could open a recordset on the Excel file'? I'm not sure how you would set about this? Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access from Excel (Office 2003)


Posting Permissions

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