L
Larry
I am using the following statement to export a query from Access 2003
to Excel.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
mstrQueryName, Me.txtExportFile, True, ""
The problem is that every cell in the new spreadsheet has a leading
single quote in it (sort of). I say "sort of" because if I write some
code in the spreadsheet, looking at the value of ever cell for a
leading quote (so I can remove it) NONE of them seem to have one. But
if I click on the cell, I can see it in the formula line and delete
it.
If I use the OutputTo method, I don't get this leading quote, but then
that truncates the memo fields to 255 characters. So that's not really
an option.
So, anyone know why the single quote is appearing with this method and
anyway I can stop it or remove it after the spreadsheet is created?
Thanks,
Larry
to Excel.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
mstrQueryName, Me.txtExportFile, True, ""
The problem is that every cell in the new spreadsheet has a leading
single quote in it (sort of). I say "sort of" because if I write some
code in the spreadsheet, looking at the value of ever cell for a
leading quote (so I can remove it) NONE of them seem to have one. But
if I click on the cell, I can see it in the formula line and delete
it.
If I use the OutputTo method, I don't get this leading quote, but then
that truncates the memo fields to 255 characters. So that's not really
an option.
So, anyone know why the single quote is appearing with this method and
anyway I can stop it or remove it after the spreadsheet is created?
Thanks,
Larry