+ Reply to Thread
Results 1 to 2 of 2

multiple excel spreadsheet into 1 Access table?

  1. #1
    Registered User
    Join Date
    10-30-2009
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    multiple excel spreadsheet into 1 Access table?

    Not sure if this should be in the Excel forum or if I should post in Access forum, but if you could help I'd appreciate it.

    I have a large amount of data spread across multiple Excel spreadsheets. To better analyze all the data, I'd like to export all spreadsheets into 1 Access database. How do I do that?

  2. #2
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: multiple excel spreadsheet into 1 Access table?

    One thing you could do is import them into access as seperate tables and run a query

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1