Is there possible we can export the data to the text file using DTS that
will have output like BCP in native data format?
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
I was able to export data from a query to a text file using an ACCESS
specification file. This is done within ACCESS. I know that I can use VBA's
TransferText to automate this task in ACCESS. However, the application is
written in VB 5.0. My questions:
1. Can I run this export procedure from VB ? If yes, how
2. If I cannot use ACCESS specification file, what can I do within VB to get
the same result?
Thanks a million