Yes/No data type exporting as True/False

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting a table into an Excel file using the DoCmd.OutputTo code
below. The table is set up where if any orders were placed for this item it
appears as either Yes or No by setting up that field as a Yes/No data type.
The file exports to an Excel file, but the field that was Yes or No shows
True or False on the Excel file.

DoCmd.OutputTo acOutputTable, "Orders Y/N - Frozen Results", acFormatXLS,
"S:\Marketing\Void Reports\Report.xls", False

First time using the DoCmd.OutputTo code. Is there something I missed?
 
Supe said:
I am exporting a table into an Excel file using the DoCmd.OutputTo code
below. The table is set up where if any orders were placed for this item
it
appears as either Yes or No by setting up that field as a Yes/No data
type.
The file exports to an Excel file, but the field that was Yes or No shows
True or False on the Excel file.

DoCmd.OutputTo acOutputTable, "Orders Y/N - Frozen Results", acFormatXLS,
"S:\Marketing\Void Reports\Report.xls", False

First time using the DoCmd.OutputTo code. Is there something I missed?
Click to expand...

You will need to change the formatting of that column in Excel. I suggest
asking how in an Excel group.
 
Back
Top