Results 1 to 4 of 4
  1. #1
    Tenmakk is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    35

    Bring data in from Excel and have that data also appear in the form

    Hello, what I've been doing in Access is manually typing out the info from Excel into a form so it will go into the Access table and appear in a new record on the form.



    I know how to bring in the data from Excel into the Access table, but when I bring in the data it only appears in the table. I want it to create a separate entry in the form as well. This is because the users managing the data don't look in the table (only in the form). Is there a way to do this?

    Could I do something like make a button on my form that, when pressed, will populate the forms fields from the Excel sheet?


    Thank you,
    Brad

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you link the Excel file into Access (into a linked table), you could use an Append Query to copy the data from your linked Excel table to the final Access table.

  3. #3
    Tenmakk is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    35
    Quote Originally Posted by JoeM View Post
    If you link the Excel file into Access (into a linked table), you could use an Append Query to copy the data from your linked Excel table to the final Access table.
    How can I make that data appear on a form record (like it would if I originally entered it into a form) though. Is it possible to do this?

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Link your Form to the data Table.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2011, 02:11 PM
  2. Capture Form Data to Export to Excel
    By ajones92 in forum Forms
    Replies: 8
    Last Post: 06-16-2011, 03:35 PM
  3. Bring in numeric text field to access from excel
    By Sck in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2010, 04:07 PM
  4. Paste Data From Excel To Access Form
    By fanzak in forum Programming
    Replies: 2
    Last Post: 08-16-2010, 02:40 PM
  5. Replies: 0
    Last Post: 03-11-2010, 02:11 AM

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