Results 1 to 2 of 2
  1. #1
    NickWren is offline Advanced Beginner
    Windows XP Access 2013
    Join Date
    Dec 2015
    Location
    Connecticut
    Posts
    70

    Need some small help with my database (importing from excel to access database using update query)

    hey I was wondering if someone could help me get this to work on my database, I need to not only import data from excel but also export the access data out of excel depending on what data you pick to come out (combobox/Checkbox to choose to get the basic information or the test results).




    Import&Export.zip
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Save the XL file to a generic name everytime....File2import.xls
    link it in access as a table.
    then make an append query to copy the XL table to your internal table.
    Make a macro to run it.
    So the steps would be:
    1. Save the new XL file to the generic name.
    2. Run the import mmacro
    done.

    the export, use a macro and run the command:
    transferspreadsheet.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-23-2016, 12:18 AM
  2. Using Excel to update Access Database
    By Swade730 in forum Macros
    Replies: 4
    Last Post: 02-20-2016, 03:12 PM
  3. Replies: 4
    Last Post: 12-16-2014, 03:31 AM
  4. Replies: 1
    Last Post: 05-28-2014, 10:59 PM
  5. Importing data into Access database from Excel textboxes
    By Sambora in forum Import/Export Data
    Replies: 3
    Last Post: 05-06-2013, 02:27 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