+ Reply to Thread
Results 1 to 4 of 4

Need Help Exporting Data From an Excel Worksheet to an Access Database

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    Denver, Colorado
    MS-Off Ver
    Microsoft Office Excel 2010
    Posts
    17

    Need Help Exporting Data From an Excel Worksheet to an Access Database

    I have a workbook that processes many rows of data and extracts a list of summary parameters which is contained on the last sheet of my workbook. My workbook needs to be able to push the data that is extracted on the last sheet to an Access database table. I am running into trouble in that Excel can only handle just over one million rows, and my list will eventually be larger than that. So I need my last sheet to push its data to Access, then be able to clear out my workbook for a new set of data to be inputted extracted, then add the extracted data to the existing list in Access, and repeat again. So my database will grow each time I run an extraction.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: Need Help Exporting Data From an Excel Worksheet to an Access Database

    From Access, use the import functionality that is available in the wizard each time you need to update the database. Not knowing which version of Excel or Access you are using, I cannot give you specific instructions. If you require specific steps, then proved which versions of each software you are using.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-25-2015
    Location
    Denver, Colorado
    MS-Off Ver
    Microsoft Office Excel 2010
    Posts
    17

    Re: Need Help Exporting Data From an Excel Worksheet to an Access Database

    Thanks, I will try to use that. My excel file will lose the data after each run, using the wizard will I be able to add to the database in a cumulative way that just adds only what is updated and doesn't get rid of the data in place? I have Excel 2010, and I am not sure what version of Access I have. I will check tomorrow when I can get back to my work computer.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: Need Help Exporting Data From an Excel Worksheet to an Access Database

    The wizard will ask if you wish to append the data to an existing table. This assumes that your excel file contains only new data. If this is not the case then you will need to jump through some VBA hoops.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Exporting data to 2 different worksheet database
    By namialus in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-09-2014, 01:58 AM
  2. [SOLVED] Exporting data to a different worksheet database
    By namialus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2014, 11:16 AM
  3. Exporting data from Excel to Access
    By Dan27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2013, 08:16 PM
  4. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  5. [SOLVED] exporting data from access to excel
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 04-11-2006, 05:17 AM
  6. [SOLVED] Exporting data from access to excel
    By vinayak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2006, 03:25 AM
  7. Exporting data from ms-access database to multiple worksheets using ASP
    By sridevi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2005, 07:06 AM

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