Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    29

    Exclamation Unanswered: Importing Excel Spreadsheet into Access

    I'm trying to import a spreadsheet from Excel to Access. The problem is that the Excel part is really a workbook and therefore has multiple spreadsheets in it. And I'm wanting to import the second spreadsheet. When you run a wizard to do an import, you can choose the worksheet name. But I don't see anywhere in a macro that I can do this. So I assume maybe I can do it using VBA. But I haven't been able to find anything to help.

    Any help would be appreciated

    Thanks,

    Bailee220

  2. #2
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    In the range of your macro put the sheet name followed by !


    Sheet2!

    Brent

  3. #3
    Join Date
    Oct 2003
    Posts
    29
    What if my sheet name is like this: 1. Pref Card Upload. I tried to use that with the ! at the end of it. And it doesn't recognize it. I'm thinking that I'm needing to use some sort of quotes but don't know exactly what.

    Any ideas?

    And thanks for the info so far. Almost got it.

  4. #4
    Join Date
    Oct 2003
    Posts
    29
    What if my sheet name is like this: 1. Pref Card Upload. I tried to use that with the ! at the end of it. And it doesn't recognize it. I'm thinking that I'm needing to use some sort of quotes but don't know exactly what.

    Any ideas?

    And thanks for the info so far. Almost got it.

  5. #5
    Join Date
    Oct 2003
    Posts
    29
    Nevermind, I figured it out! Thanks again for all your help!

Posting Permissions

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