1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,283
    Likes Received:
    364
    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