Results 1 to 5 of 5
  1. #1
    mit is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    12

    transfer multiple excel files to multiple tables in Access

    Hi,


    I have 5 excel files and I need to transfer them into Access Database.I need a code to create 5 tables and transfer data in them.
    (there should be one table for each excel file)
    thanks

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you should be able to use the below link to produce the code yourself: http://www.access-programmers.co.uk/...multiple+excel

  3. #3
    mit is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    12
    Thanks alot,it's exactly what I want.
    in this code all the tables have numeric names from 0 to ....
    I want them to ham my excel file's name.I should change the part of code.I found a function but I do not know how to change it.

    for example,this is my full path=c:\myexcelfiles\file1.xls
    I need the part of path like "file1".
    can you help me please.

  4. #4
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    not sure HOW to, my friend.

    you said you found a function, but that's it. how could I help you with just that?

  5. #5
    mit is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    12
    Thanks again,my problem has solved with the link you have posted

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

Similar Threads

  1. Replies: 9
    Last Post: 10-31-2013, 06:51 AM
  2. Importing Excel datasheets into multiple tables
    By FishMT in forum Import/Export Data
    Replies: 3
    Last Post: 02-08-2011, 07:44 AM
  3. Replies: 4
    Last Post: 07-15-2010, 05:58 PM
  4. Replies: 2
    Last Post: 05-25-2010, 02:45 PM
  5. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 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 - Senior Forums