Export table information into an existing Excel Spreadsheet.

[chanman525]

I have a table that has 2 fields with 5 rows of information. I'm trying to export those 5 rows into an existing spreadsheet. I would like them to export right into Column C Cell 1811 - 1815 and D 1811-1815. Can this be done through a macro or should it be coded?

 

[richand1]

Where are you importing the data from?

 

[chanman525]

I'm trying to take information out of an Access Table and export it out to a group of cells in Excel.

 

[richand1]

How about using MS Query?

 

[chanman525]

Well I would actually like to automate it because it's something that will be run on a regular basis. That's why I was wondering if there was a way through code to do this, so I could just run the module through a macro.

 

[richand1]

When you set up the data source in MS Query, go to the Advanced options and set it to refresh on open.
Then write a brief piece of code/record a macro that will refresh the data when you need to.

This is as far as my knowledge of this goes I'm afraid; might suffice as a quick fix though until someone can help with the code maybe?!

Rich