Re: OutputTo verus TransferSpreadsheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob Oldfield (blah_at_blah.com)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 11:21:04 -0000

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?

"Bill Sturdevant" <BillSturdevant@discussions.microsoft.com> wrote in
message news:0586994D-3EF8-457F-8B1D-65751455321D@microsoft.com...
> 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?

Relevant Pages