Formatting in export to ms excel

[Imran Ghani]

Hi! I am working with ms access 2007 and ms excel 2007. I wanna export my
data to excel 2007. Kindly guide me about the specific command for that. Is
it also possible if we wanna have all our cells formatted as a box around
them. Thanks in advance.

 

[Piet Linden]

Hi! I am working with ms access 2007 and ms excel 2007. I wanna export my
data to excel 2007. Kindly guide me about the specific command for that. Is
it also possible if we wanna have all our cells formatted as a box around
them. Thanks in advance.

Having trouble finding F1?

Hmm... TransferSpreadsheet just *might* work.

 

[Douglas J. Steele]

Note, however, that Piet's only given you part of the answer: how to export
the data to Excel.

Putting a box around the cells is a much hard proposition. You cannot export
formatted data to Excel: your only option is to use Automation to
programmatically do the formatting in Excel.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi! I am working with ms access 2007 and ms excel 2007. I wanna export my
data to excel 2007. Kindly guide me about the specific command for that.
Is
it also possible if we wanna have all our cells formatted as a box around
them. Thanks in advance.

Having trouble finding F1?

Hmm... TransferSpreadsheet just *might* work.