+ Reply to Thread
Results 1 to 5 of 5

Import data from Access database

  1. #1
    Registered User
    Join Date
    07-19-2019
    Location
    Milpitas, California, USA
    MS-Off Ver
    2013
    Posts
    2

    Import data from Access database

    Hi all,

    Apologies if I go against any procedures or policies here as this is my first post.

    I am trying to import several sheets of data from an Access database into several sheets in Excel. I can do this manually with no problem (going to DATA Tab, slecting the "From Access" icon and going through the steps), so I tried recording a macro while manually going through the steps. See below for code. Now if I run the code, I get the following error "Run-time error '1004': Application-defined or object-defined error.

    Please Login or Register  to view this content.
    Last edited by Mark555; 07-22-2019 at 12:44 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,812

    Re: Import data from Access database

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I added the tags for you this time. Please read forum rules. Thx

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,812

    Re: Import data from Access database

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "Over the Hills" ( country will suffice, no need to be more precise).
    Thank you for helping us help you

  4. #4
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,132

    Re: Import data from Access database

    Look at this link on how to go from Access to Excel which may be easier using VBA

    http://www.accessmvp.com/KDSnell/EXCEL_Export.htm
    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

  5. #5
    Registered User
    Join Date
    07-19-2019
    Location
    Milpitas, California, USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Import data from Access database

    alansidman, sorry for my ignorance on this. I looked through your link and from what I can tell, none fit what I'm trying to do. Due to propriatary information, I can't publish the Access file but below are the maual steps I use to open the file for my needs.

    1) open and save a new excel file called "C:\datafile.xlsx"
    2) go to DATA tab and click on "From Access" icon.
    3) select file "X:\access_data.accdb"
    4) on the "Select Table" pop-up, check "Enable selection of multiple tables". Then select "Name" which selects all tables.
    5) Click OK
    6) At next pop-up, choose "Table and click OK.

    After this, all tables will load. And that's it!

+ 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] Access Database Import Data From Specific Date Range
    By djsouljah in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-29-2015, 11:47 AM
  2. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  3. Is it possible to import data to excel from an access database online?
    By Rob* in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2012, 04:22 AM
  4. import tables in to access from another access database
    By jsimha in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-16-2010, 05:31 PM
  5. Open an Access database Import data like Microsoft Query
    By hilander in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2007, 06:55 PM
  6. How to import data from Access Database.
    By vidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2006, 02:35 PM
  7. Replies: 0
    Last Post: 03-15-2005, 03:06 PM

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