none
Import multiple excel tabs to access RRS feed

  • Question

  • Hi, How can I import a single excel report with multiple tabs (same column structure) to access. I was doing it tab by tab and takes a lot of time.

    Regards.

    Wednesday, June 6, 2018 8:29 PM

Answers

  • Hi Frank,

    You can use code. For example, you could try using the TransferSpreadsheet method.

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "TableName", "FileName", True, "TabName"

    Hope it helps...

    • Marked as answer by Frank3623 Friday, June 8, 2018 3:53 PM
    Wednesday, June 6, 2018 8:54 PM
  • Nice, I'll try it! look very promising Thanks!

    Good luck! You can create a function to perform multiple Excel imports by changing the name of the table and Excel tab for each line.

    Cheers!

    • Marked as answer by Frank3623 Friday, June 8, 2018 3:52 PM
    Wednesday, June 6, 2018 9:12 PM

All replies

  • Hi Frank,

    You can use code. For example, you could try using the TransferSpreadsheet method.

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "TableName", "FileName", True, "TabName"

    Hope it helps...

    • Marked as answer by Frank3623 Friday, June 8, 2018 3:53 PM
    Wednesday, June 6, 2018 8:54 PM
  • Nice, I'll try it! look very promising Thanks!
    Wednesday, June 6, 2018 9:07 PM
  • Nice, I'll try it! look very promising Thanks!

    Good luck! You can create a function to perform multiple Excel imports by changing the name of the table and Excel tab for each line.

    Cheers!

    • Marked as answer by Frank3623 Friday, June 8, 2018 3:52 PM
    Wednesday, June 6, 2018 9:12 PM
  • Hi Frank,

    Sorry for jumpint into this thread.

    I found you have posted multiple threads and they are resolved. I would suggest you mark the solutions as answer to close threads below:

    Multiple iif and range conditions

    Lookup & Match in Access

    If you have any unclear about this, please feel free to let us know.

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by Frank3623 Friday, June 8, 2018 3:50 PM
    • Unmarked as answer by Frank3623 Friday, June 8, 2018 3:52 PM
    Thursday, June 7, 2018 6:22 AM