Results 1 to 2 of 2
  1. #1
    pharmacologist is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    39

    Best way to insert record from Excel table to Access table with same field headings in VBA


    Been coding an excel workbook and I want to export data from a table in my workbook into an identical table in access. It has a lot of fields and I'm wondering if there is a more efficient way to do this than update each field, i.e. is there an automatic way since the table designs are identical.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Why are you using an Excel workbook at all?

    There is no 'automatic' way. Use code to run INSERT and/or UPDATE action SQL. Access can link to Excel sheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 02-13-2017, 10:08 PM
  2. Replies: 10
    Last Post: 11-01-2016, 07:06 AM
  3. Column Headings - Change before uploading to Access Table
    By smoothlarryhughes in forum Import/Export Data
    Replies: 5
    Last Post: 11-08-2012, 12:33 PM
  4. Insert record from table into different table
    By tpcervelo in forum Forms
    Replies: 3
    Last Post: 01-25-2011, 02:41 PM
  5. Replies: 2
    Last Post: 12-22-2010, 01:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums