Report to Excel Problem

[bloise]

I am having a problem exporting an access report to excel.
I am using the following logic,
"DoCmd.OutputTo acOutputReport,,acFormatXLS"

Everything works fine except:

1. I loss the date format in one of my columns
2. My first column which contains headings are also messed up. Some of the columns are including invalid headings.

Any suggestions would be helpful..
Mike

 

[BoxOfMoonlight]

Do you NEED the report in Excel? If not, you could export your report to Word or export your underlying qry to Excel.

 

[bloise]

Yes, the client receiving the file wants to import the data into their database. DB imports work rather well with excell. I figured out problems 2. The name of my text boxes on the report were incorrect.

I am still having a problem with the dates... Any clues??
Mike

 

[bloise]

Well, I found how to fix the date problem. If you call the function format$(dateVar), it solves the problem when exporting the report to excel. Thanks all for the help.