Macro to import data from access

jcaple · Feb 17th, 2002, 04:22 AM

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 · Feb 17th, 2002, 05:21 AM

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 · Feb 17th, 2002, 07:43 AM

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 · Feb 17th, 2002, 10:09 AM

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 · Feb 18th, 2002, 06:55 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 17th, 2002, 04:22 AM	#1
jcaple New Member Join Date: Feb 2002 Posts: 2	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?

Feb 17th, 2002, 05:21 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Feb 17th, 2002, 07:43 AM	#3
Tom Morales Board Regular Join Date: Feb 2002 Location: Richland, Washington Posts: 91	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

Feb 17th, 2002, 10:09 AM	#4
jcaple New Member Join Date: Feb 2002 Posts: 2	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 ]

Feb 18th, 2002, 06:55 AM	#5
richey New Member Join Date: Feb 2002 Location: Manchester, England Posts: 7	http://www.tek-tips.com is excellent