Consulting

Results 1 to 6 of 6

Thread: Solved: Automatically import data from Access DB in Excel

  1. 03-16-2009, 08:08 AM #1
    john3j
    john3j is offline
    VBAX Contributor
    Joined
    Mar 2009
    Location
    Indiana
    Posts
    113
    Location

    Solved: Automatically import data from Access DB in Excel

    Hey guys,

    Im trying to eliminate human interaction because we all know people just tend to mess things up. I have an excel sheet that has multiple pages that sorts and then calculates data to create charts. As of now, I am going into my database....microsoft access db...and i am running a macro that pastes the data into a new spreadsheet. From here, I am opening the spreadsheet that was created, selecting rows 2 thru 1000, and then pasting them into row two of my workbook that was created. If there any way to make it so that when I run the macro, it will populate into my workbook, while preserving all of my premade sheets? Let me know! Thanks!

    John
    Reply With Quote Reply With Quote
  2. 03-16-2009, 08:13 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Why not just run a simple Excel query to pull the data from Access?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 03-16-2009, 09:35 AM #3
    john3j
    john3j is offline
    VBAX Contributor
    Joined
    Mar 2009
    Location
    Indiana
    Posts
    113
    Location

    query

    Well, a simple query would be nice...but I dont know how. I went into my workbook and went to Data--> Import External Data -->Import Data and selected my table that i want to import the data from. However when it does it, it only pulls the first row and nothing else happens...and the first row is just the headers. I do know that my database is linked with Sharepoint and it pulls data each time you run a macro. Is there any other way to do it?
    Reply With Quote Reply With Quote
  4. 03-16-2009, 09:48 AM #4
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I know so little about SharePoint, it isn't even funny.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  5. 03-16-2009, 10:23 AM #5
    john3j
    john3j is offline
    VBAX Contributor
    Joined
    Mar 2009
    Location
    Indiana
    Posts
    113
    Location

    re

    Well you could help with my other two if you have time!
    Reply With Quote Reply With Quote
  6. 03-16-2009, 10:29 AM #6
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Which other 2?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules