Results 1 to 3 of 3

Import Excel data to Access form, display it, add additional Data and push to Access Table

  1. #1
    elzool is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2016
    Posts
    1

    Import Excel data to Access form, display it, add additional Data and push to Access Table

    I've inherited a few duties and while I can do them as is, I'd like to make them more efficient and could use some assistance in doing so.
    If I am in the wrong forum, I apologize, it seemed that this would be a good place to start.



    This is what is happening now.
    We send users an Excel form to fill out and periodically they fill it out and email it back to us as necessary.
    When the form is returned, I manually input that data into an existing Table in Access.

    This is what I would like to do.
    Using Access 2013, I would like to create a form where I could browse for an Excel spreadsheet, select it and display data from

    Excel on the Access form. Then, on the Access form, I would manually add additional data via dropdowns and text boxes and export all of that into an existing Access table. Once the data has been exported and placed into the table, I would like the ID number it created, displayed on the form itself.

    So, right now, there is data on the Excel form that is input using text boxes and dropdown list selections.
    I have all of the data I would like added to Access being copied to specific cells on an individual sheet within the spreadsheet as well. Within Access, the table we put the information into has the same selections as the Excel dropdowns, but further information also must be entered into that row in the Access table that is not on the Excel form.

    I've created a form in Access that would allow me to enter the additional information using dropdowns and textboxes.
    It also has the ability to browse for a file, select it and display a path.

    The other fields I would like to display are also set up, but I do not know how to populate them or go beyond this.

    I would really appreciate some assistance with this.

    Thank you so much in advance!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,766
    dont import certain cells, import ALL cells.
    import the data to a temp work table, (dont work in excel, unless you do it ALL in excel)
    make your adjustments in a form connected to this table, add your extra data
    if you need to do it in bulk, run an update query on the temp table.
    then when updates are finished, run an append query to add the data to the main data table.

  3. #3
    AlexJ is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    19
    Interested to see if you found a solution for this. I am looking to do a similar thing that involves browsing and adding two .csv files to two tables then using a make table query to combine them only pulling the information I want then exporting this new table all using buttons in a form. Could you share your method/VBA for your browse and import function?

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

Similar Threads

  1. To import Excel data to a table in access through form.
    By vibinmvenugopal in forum Access
    Replies: 1
    Last Post: 09-26-2014, 05:24 AM
  2. Replies: 6
    Last Post: 07-31-2014, 11:53 AM
  3. VBA - Import Excel Data into Access Table
    By sikhinvestor in forum Import/Export Data
    Replies: 2
    Last Post: 04-28-2014, 12:43 PM
  4. Import Excel data into existing Access Table
    By octsim in forum Import/Export Data
    Replies: 4
    Last Post: 10-24-2013, 06:21 AM
  5. Replies: 5
    Last Post: 05-09-2013, 05:47 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
  •  
Tech Forums: Microsoft Office Forums