Hi Gary,
Is there a way to export data to word via VB with a Sybase
back-end without converting the database to Access?
Assuming Sybase has an OLE DB provider that will work with
ADO, then yes. Using DAO + ODBC Direct would also probably
work if Sybase only has an ODBC driver. Since you apparently
know it can be linked into Access, it must have the latter, at
the very least.
In either case, you'd need to ask in a database group how to
create the actual connection and work with the data.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail