importing access data

[Fubardave]

I want to put certain pieces of access data in a specific location on an
excel file.

Should I just import the data as a new sheet and then write the appropriate
excel formulae/coding to distribute these where needed or is there a cleverer
way of doing this ?

 

[CLR]

If I were going to do this more than once, my approach would be to write a
macro that will use MSQuery to import the ACCESS data to a helper sheet and
then use further macro commands to copy the data from there to where you want
it and then delete the helper sheet. If only once, then as you describe in
your second sentence.

Vaya con Dios,
Chuck, CABGx3

 

[Fubardave]

Would you have an example of this code CLR ?

If I were going to do this more than once, my approach would be to write a
macro that will use MSQuery to import the ACCESS data to a helper sheet and
then use further macro commands to copy the data from there to where you want
it and then delete the helper sheet. If only once, then as you describe in
your second sentence.

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Macros involving MSQuery are very specific as to the path, filename,
selections to be retrieved, etc.....looking at one of my old ones wouldn't do
as much good as if you were to turn on the MacroRecorder and go through the
process by hand and yourself then turn off the Recorder and then you have
something specific to your setup that you can edit..... to get there, after
turning on the recorder, do Data > GetExternalData >
NewDatabaseQuery.....then follow the menus.

hth
Vaya con Dios,
Chuck, CABGx3