Results 1 to 2 of 2
  1. #1
    mari_hitz is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    28

    Question Import data from Excel

    Hi guys!



    My name is Marina and I am new at the forum. I would like to get more information on how to import data from excel to access.
    I have a sort of tool created in Excel used for people to send me technological errors. To add information to this "tool" people use userforms.
    On the other hand I have an access database with all the technological issues reported. I would like to know if is possible that this information uploaded to the excel can be exported to access. I saw that it is possible with VBA codes, however, how do I do this? I have to create a table in acess and then add a macro there? or how will this work?
    I am sorry if I do not make myself clear, I do not have much knowledge of this.

    Thanks a lot!

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    You could link the Excel file to Access as a table and then you can use queries to import/update the data.

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

Similar Threads

  1. Import to Excel from Access column of LOOKUP data type
    By Derek in forum Import/Export Data
    Replies: 1
    Last Post: 12-06-2010, 06:27 PM
  2. Replies: 1
    Last Post: 10-29-2010, 02:53 PM
  3. Excel Import/Append Data (weekly)
    By MartinL in forum Import/Export Data
    Replies: 1
    Last Post: 08-12-2010, 06:14 PM
  4. Automate Import of Excel data
    By tpcervelo in forum Import/Export Data
    Replies: 2
    Last Post: 07-29-2010, 12:19 AM
  5. Using Import wizard to get Excel data
    By Jack Sheet in forum Import/Export Data
    Replies: 5
    Last Post: 07-16-2010, 09:44 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