Export Query to Excel Cell 1

[ghloid]

Hi all,

We have several queries in Access that we would like to populate a spreadsheet of excel. We have the worksheets all made up with little tables of information that are then used to make charts on the worksheet(s). I want to populate the tables on the worksheet with the query information, but I can't simply use the Transfer text option as it will put the data in the first cell of every worksheet (A1). How can you tell Access to populate the worksheet starting at a specific cell? There has to be a way (you would think), but I have yet to see anything.

If anyone knows, I'd appreciate the help.

Thanks!!

 

[mdthornton]

You should use transferspreadsheet rather than transfertext but unfortunately you can't specify a range with this method when exporting

If its an option it might be better to pull the data from the excel side. you should be able to control where the data ends up this way. Best Regards,
Mike

 

[blom0344]

hello ghloid,

To complement mdthornton: This is an excellent case to use ODBC connection from your excel-spreadsheet to the source data in Access.

Simply go to control panel and open ODBC data sources. Go to tab system DSN and click add. Choose the Microsoft Access driver, fill in a name and choose the correct path to the database. If you use data --> create new query in Excel , you can set up download query to any of the tabels in your access database. In the downloadproces you can even specify to which starting cell it should be imported. Refreshing of data in your spreadsheet is by : data --> refresh.