Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    importing from Excel to Access (OfficeXP Pro)

    I have to import data from an Excel workbook into Access. The data is in 12 worksheets and I put the data into 12 corresponding tables. I use
    DoCmd.TransferSpreadsheet acImport, .....
    for each of these worksheets.

    Here is the opinion question of the day. Is there any advantage to doing the TransferSpreadsheet method above over
    using ADO to create a link with the ActiveConnection property in Recordset objects?

    Thanks,

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: importing from Excel to Access (OfficeXP Pro)

    Two issues here in my opinion. Importing prevents you from inadvertently modifing the spreadsheet and also lets you work with the data in multi-user mode (Excel is a single-user product). Also, I think you find performance is significantly better with Access tables if your tables contain large numbers of records.
    Wendell

Posting Permissions

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