Results 1 to 2 of 2
  1. #1
    henjin is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012

    Access database with import excel table slot


    first of all I want to greet you all. This is my first post here.. Horaaay

    I must say I am not found of Access, the last time when I used it it was in middle school :/ but unfortunately because of my job I need to use it more and more... damn databases... hahah...

    My question is, I need to make a database, like a main database where I can import all my data from different excel tables. I know that there is the possibility to import, but the thing is I need to have the ability to choose where to import which column... how to do that?... oh yea all the import excel data should have a separate table in the database and should be also shown in a "main table" where every data should be...

    Thank you all upfront

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Tulsa, Oklahoma.
    In your Database:
    1. Click External Data on the top.
    2. Click Excel.
    3. Follow the directions given to you by the wizard.
    4. You can save the steps when you're done.

    If this is something you have to do on a regular basis, you can create a Macro - Create -> Macro - and then use the 'ImportExportSpreadsheet' action to specify which spreadsheet you want to import.

    I do this a lot.
    In my Macros, I have Delete Queries that empty the tables in Access - and then I have all these ImportExportSpreadsheet actions that pull the new data in to each table - from different spreadsheets.

    Let me know if you need more help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import from Excel to Access
    By Phred in forum Programming
    Replies: 13
    Last Post: 05-16-2012, 12:25 AM
  2. import from excel to one table
    By mojtaba79 in forum Import/Export Data
    Replies: 4
    Last Post: 06-22-2011, 05:39 PM
  3. Upload (import) Excel Table Info
    By AKQTS in forum Access
    Replies: 2
    Last Post: 04-21-2011, 02:07 PM
  4. Disabling Excel import to a specific table
    By JoshD in forum Import/Export Data
    Replies: 0
    Last Post: 04-15-2011, 02:26 PM
  5. Replies: 1
    Last Post: 11-21-2010, 10:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums