Whenever I use the TransferSpreadsheet command to export data to an Excel sheet, it always populates a quote character (') in the 1st position of all of the columns. How can you avoid this? I tried different arguments to this function, but I can't see the difference. Also, what are the differences between acSpreadsheetTypeExcel9, and acSpreadsheetTypeExcel3 etc.......???

The last question first: those are versions of Excel, like 95, 97, 2000, XP, 2003, etc. They each have version numbers and supported features.

As to the apostrophe, I know there is a way to remove it (saw it in one of my reference books) but can't find it. Excel puts it there to indicate that the field is text, and not numeric. Excel ignores it and does not display it, except in the text bar. Is this causing problems with your Excel actions? If so, perhaps transferring to a template would work better if you need the cells formatted, or get down and dirty and format the spreadsheet from Access.

mmcdonal

Thank you so much mmcdonal for responding. The data gets produced from ACCESS into EXCEL and then is used by downstream folks for various reasons. My client is afraid that the apostrophe will cause problems for users who have scripts which go against this data, and will now encounter that 1st character. You're saying however that this may not be the case? Also..a general Forum Question..this is my 1st topic that I've posted. How do you navigate around here? Meaning..best way to find answers to topics you may have questions on? Best way to locate your own Topics...I only see filters for the day that topics get posted etc....

I bet that even if you tried to refer to those apostrophes with a script, you couldn't do it. Execute one and see what happens.



mmcdonal