OutputTo verus TransferSpreadsheet

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

Guest

I am using OutputTo to export data to a series of spreadsheets. But it is
slow and frequently just causes Access 2002 to crash.

I would prefer to use TransferSpreadsheet because it is much faster and
appears to be more stable. BUT, it puts those apostrophes in front of text
data values.

How can I avoid that?
 
Why does it matter? The ' is just Excel's default prefix to say "This is
text". They don't display or print. What's the problem with them?
 
Back
Top