Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    6

    Question Unanswered: exporting multiple excel file then append to MS Access tables

    Hi,

    Does anybody with this one. I have 3 different tables in MS access (table1, table2,table3) that contain different data. Data are coming from Ms Excel (xl1.xls, xl2.xls, xl3.xls).

    How can I possibly do openfile and then can select one time all the 3 excel file I have and then can append it automatically to access table :table1 for xl1.lxs , table2 for xl2.xls and table3 for xl3.xls.

    I want to do the code in VBA access. thanks!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You want to look at doCmd.TransferText
    That's your starting point.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •