Macro to import data from access
Macro to import data from access
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Macro to import data from access

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I used the 'record new macro' function to copy data from two columns of my access database, and paste it into my spreadsheet. This works fine until I add another record, therefore meaning another field in each column. When I then run the macro, it only imports the same records as before, and does not include the new data. Any idea how to change the macro so that it includes all of the records in those two columns?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I think you'll need to paste your code. How did you get the data from Access, was it with a query i.e. Data, Get External Data, New Database Query?

    Regards,
    D

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Richland, Washington
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    jacple -
    I'm not sure you're on a success path by the recording of the copy/paste process with Access data. (Not having done it, I'm not really sure.)

    What might be more fruitful is recording the query process through Data/Get External Data. That I've done, and it works.

    Tom

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone! Got the macro working properly now, so I might yet finish my AS level coursework in time!
    Anyone know of an equally good MS Access message board?!?
    [ This Message was edited by: jcaple on 2002-02-17 09:47 ]

    [ This Message was edited by: jcaple on 2002-02-17 09:49 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Manchester, England
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com