How do you dump Access data into an already formatted Excel sheet

[colezpapa3]

I am developing an app for someone that will replace an EXCEL sheet. When printed, the sheet fills a landscape legal sheet and is formatted. What I would like to do is click a button and export my datafields into an excel but have it formatted like her sheet is currently. How would I go about this....

 

[Brunn]

Perhaps someone else would know better than I, but to my knowledge, when transferring data to excel, you lose all formatting. There isn't a way to pre-format your data to match what is setup in excel.

 

[SkipVought]

Easiest to pull the data from Excel using Data > Import External Data...

Your sheet format will remain in tact.

You can configure the query table Data > Import External Data > Data Range Properties to refersh the query on open if desired.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[Remou]

A work-around may suit. You can:

* Format an exported sheet with automation
* Add data to a formated sheet with automation
* Attach the data to the Excel sheet with a query.

 

[PaulBricker]

Have a look at this article about using Excel templates. It should allow you to export your data to Excel and retain the formatting in Excel you need.

http://www.databasejournal.com/features/msaccess/article.php/3563671

Paul

 

[colezpapa3]

Thank you all. I will let you know how it goes.