[AccessD] Access Toolbar Question

Hi Steve,
Yes, I think you may be right, and there is another issue here which has
just been brought to my attention.
Apparently (I haven't checked) but the TransferSpreadsheeet method truncates
at 255 characters  (in a Memo field for  example) whereas, I am told, the
CSV method does not.
This will impact on  my EATBloat program which defaults to the
Transferspreadsheet method (there is the CSV option there, but commented out
and with no Form interface).  Once I have tested these assertions, then I
will have to make some changes.
Thanks for the feedback.
Regards
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Wednesday, September 05, 2007 7:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Toolbar Question

Max,

I have sometimes found that OutputTo method can be preferable to
TransferSpreadsheet in cases like this, as data typing and formatting seem
to be better retained.

Regards
Steve


Gmail wrote:
> Hi Arthur,
> This will output a Table or Query into Excel
> 
> DoCmd.TransferSpreadsheet acExport, , "qBELnk_MenuGroupsSub", 
> "C:\qBELnk_MenuGroupsSub", True ' change output path to suit.
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com