Linking an Access query to excel spreadsheet

[Neil_Pattison]

Hi all, any help would be greatly appreciated.

I need to be able to take the data from a query and export it to an excel spreadsheet that is in a set format (the format can be anything as not decided yet).

I know how to export a full record to excel but I need to be able to to export it so that the data from a field goes to a specific cell in excel. How do I link a field to a specific cell?

Also is there a way of letting the spreadsheet in excel be updated and then imported back into access and thus updating the data in access database.

Any help would be great, thanks

 

[Pat Hartman]

To export a table or a quey you can use the TransferSpreadsheet Method. If you need to export fields to specific cells, the only way to do it is with VBA. You need to use automation to open the spreadsheet and copy data from an access recordset to individual cells.

Are you sure you can't use a query to solve your mapping issue?