|  | export to exce spread sheet | | |
| | | SageOne |  |
|  Posted: Tue Aug 26, 2008 12:26 am Post subject: export to exce spread sheet |  |
can i set and save certain format properties for my excel spreadsheet to
display when exporting a spread sheet from access? for example, if i generate
a spread sheet in access and always want to export a spreadsheet into excel
with all data "center aligned" in the excel columns. |
| |
| | | Tom van Stiphout | |
| | Posted: Tue Aug 26, 2008 1:38 am Post subject: Re: export to exce spread sheet | |
On Mon, 25 Aug 2008 19:26:02 -0700, SageOne
<SageOne@discussions.microsoft.com> wrote:
This worked for me:
Export data using DoCmd.TransferSpreadsheet.
Open the file just created, select the worksheet just created.
Format a column as centered.
Delete all data but leave the worksheet in place
Re-run the export
Observe the column is still centered.
-Tom.
Microsoft Access MVP
| Quote: | can i set and save certain format properties for my excel spreadsheet to
display when exporting a spread sheet from access? for example, if i generate
a spread sheet in access and always want to export a spreadsheet into excel
with all data "center aligned" in the excel columns. |
|
| |
|
|
