Exporting to Excel: formatting lost??

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi there,

I need to export a table from Access as an Excel sheet, and I want to do
this programmatically. I therefore use the 'TransferSpreadSheet' method.
But the formatting (fonts, size, etc) of the table is lost in that case!

On the other hand if I select the table in the database window and then
click on the Excel icon in the toolbar to export it, the data is
displayed correctly in Excel. But I don't want to give my users access
to the database window!

So how can I combine the 2 methods to get the results that I want??

Any help is greatly appreciated!

Jerome
 
Check out the "OutputTo" method of DoCmd. It tends to mimic the UI behaviour
that you prefer (i.e., Office Links or Save formatted). Be sure to also read
the related Action topic for greater detail.

HTH,
 
An Access table does not have formatting (fonts, size, etc) in the table -
only data.
 
Yes, I know. But you can format the data in the table in Access and then
export it like that into Excel. And that's what I want to replicate
programmatically ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
"External table not in expected format" 7
how to export with format using TransferSpreadsheet 4
export to excel and format excel rows? 5
Exported Excel File is Incomplete 14
Exporting pivot tables 2
Exporting to Excel 2007 1
Format for Exporting Access data 1

Back
Top