Macro to import data from access

[jcaple]

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?

 

[dk]

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

 

[Tom Morales]

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

 

[jcaple]

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

 

[richey]

http://www.tek-tips.com is excellent