Results 1 to 3 of 3
  1. #1
    AKQTS is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    56

    Upload (import) Excel Table Info

    I am kind of stumped on how to do this one...



    I have excel files I want to import the data from into my Access table.

    The Excel files are bascially column X, Y, and Z with a varying amount of records between each files.

    I am hoping to have the user be able to browse and select the Excel file from my Access program. Then have my Access program automatically import the data from the Excel file into my Access table.

    Any thoughts?

    Thanks

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this can be modified to accomplish what you need: http://www.access-programmers.co.uk/...multiple+excel

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    hmmm well the " browse and select" aspect of it is challenging.

    One can easily instruct user to always put the file in folder X, and give name XYZ - - because of course the import can be prewritten to path X, file xyz.

    But to dynamically browse would be a different animal - - one would then need to identify the path on the fly. Possibly you could set up a hyperlink data field - as a vehicle to trigger the browse & select feature - - and then parse that value and put it into your import command.....

    probably other, and better, ways to do it...haven't seen this need.....

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

Similar Threads

  1. Disabling Excel import to a specific table
    By JoshD in forum Import/Export Data
    Replies: 0
    Last Post: 04-15-2011, 02:26 PM
  2. Replies: 3
    Last Post: 01-31-2011, 11:47 AM
  3. Replies: 1
    Last Post: 11-21-2010, 10:26 PM
  4. VBA to get info from excel
    By cowboy in forum Programming
    Replies: 5
    Last Post: 06-27-2010, 10:55 PM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 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