I have recently started using VB having migrated from using Access VBA. In Access VBA there is a TransferText function which saves the selected table as a comma delimited text file. I cannot for the life of me find out how to do this using VB 5.0 or 6.0.
Any help would be greatly appreciated
Thu, 06 Dec 2001 03:00:00 GMT
Tomasz Kopac #2 / 3
Exporting a table as a txt file Help!
Quote:
> I have recently started using VB having migrated from using Access VBA. In > Access VBA there is a TransferText function which saves the selected table > as a comma delimited text file. I cannot for the life of me find out how to > do this using VB 5.0 or 6.0.
Sorry - You have to write simple funtion, which open recordset and write to txt..
Fri, 07 Dec 2001 03:00:00 GMT
Col #3 / 3
Exporting a table as a txt file Help!
There is a good example of how to do this at www.smithvoice.com/vbfun.htm
-- Colin
ICQ 25808282
Quote:
> I have recently started using VB having migrated from using Access VBA. In > Access VBA there is a TransferText function which saves the selected table > as a comma delimited text file. I cannot for the life of me find out how to > do this using VB 5.0 or 6.0.
Exporting a table as a txt file Help!