Post reply

How to import Excel Data into More than One Tables

  • August 22, 2005 at 10:21 am

    #168405

    Hi, I have a new mission to update ACCESS tables everyday with a Excel file and tried to use the import wizard to do it.  But the import wizard only works for one table.

    Did anyone have the experience to import Excel data into more than one related tables?  What is the best way to do it? 

    Any suggestions and advices are apprecaited.  Thank you!

    Autumn1008

  • August 23, 2005 at 2:33 am

    #584160

    Suggest you import all the data onto a temporary table, then you can process to related tables as required

    HTH

    Robin_L

  • August 23, 2005 at 3:20 am

    #584166

    Does your Excel file have more than one worksheet? If this is the case you can create a linked table to each worksheet and run append queries from each of them in turn.

    --
    Scott

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply