Best Way to Import Multiple Spreadsheets

Discussion in 'MS Access' started by Pamela Flad, Jun 13, 2007.

  1. Pamela Flad

    Pamela Flad New Member

    Joined:
    Jun 13, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Has anyone worked with multiple spreadsheets that needed to be imported into an Access database? What is the simplist/best way to combine the spreadsheets prior to importing them. Or would it be better to create a macro that automatically imports the multiple spreadsheets one by one (going to the same table in access).
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    When you import it has the options as far as I remember. Try your hands on and you will see the option available.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice