OutputTo verus TransferSpreadsheet

B

Bill Sturdevant

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?
 
R

Rob Oldfield

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?
 
Top