AnsweredAssumed Answered

vrf tracking and displays

Question asked by VRFuser on Nov 16, 1999
I want to write my access record out to an Excel file like when you click
Tools=>Office Links=> Analyze with MSExcel

I can do it with the Access 8.0 Automation Server DoCmd.OutputTo() function,
but I want to do it with DAO library. It seems I can use the connect
property, but the VB documentation references parameters like
ODBC;
DATABASE=database;
UID=user;
PWD=password;
DSN= datasourcename;
[LOGINTIMEOUT=seconds;]

I can't figure out how to get this to work in VEE.

Does anyone else know how to use DAO to Export a table to EXCEL?
This is my first experience with Access and DAO and so far it's a real pain
in the you know what.

David Paslay - Engineer
mailto:dpaslay@coinco.com
web http://www.coinco.com
Coin Acceptors Inc.
300 Hunter Ave.
St. Louis, MO 63124
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.hp.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.hp.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.hp.com".
---------------------------------------------------------------------

Outcomes