Suddenly getting ' before text fields when exporting to Excel

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

Guest

I've been exporting to Excel using Transfer Spreadsheet in a macro for quite
some time. All of the sudden, I get a single quote ' preceding all of the
text fields in the spreadhseet after import. I know I can get around it by
sending it to .csv, but I really need it in .xls (macors attached, other
sheets, etc) any ideas?
 
The presence of ' at the front of text data when exporting from ACCESS to
EXCEL is pretty normal. That is how EXCEL knows to treat the data as text
and not date or numeric or such.

The ' characters should not interfere with anything you're doing in EXCEL,
so you should be ok.
 
Thanks, I've been exporting it for over 2 years and just now the ' is
suddenly appearing on export. I'll have to test any implications this has
down the line for my process (may be importing to another DB - was hoping to
use an existing import process)
 
Back
Top