Export data to a formatted spreadsheet

[Guest]

Hi,

I want to be able to export specific data from a record in a database out to
a spreadsheet that is already formatted. (i.e. export one piece of data into
cell B12, export another into cell C20, etc). Does this make sense? I know
it's easy to export data out to excel, but how do I export it and format it
at the same time?

My goal is to export it to a "form" I've created in excel, send this off to
someone to update the data, and then import the updated form back into the
database.

Can this be done? Any ideas how?

Thanks!

 

[Guest]

What is the format you would like to retain? Exporting to Excel, the format
identified in Access copies to Excel. The problem is that some number
formats in Access are not recognized in Excel and can cause an error. If it
is color, size, or other formatting, then those are lost during the export.
The solution I have used for this is to create a query in Excel that imports
the data from Access, and you can set it up to retain the Excel formatting.

 

[John Nurick]

Hi Heather,

You can either use Automation (sample code at
http://www.mvps.org/access/modules/mdl0006.htm)
or use queries that treat cells as one-column, one-row tables, e.g.

UPDATE
[Excel 8.0;HDR=NO;Database=C:\MyWorkbook.xls;].[Sheet1$B1:B1]
SET F1=123.45
;