I am working on a project that requires me to use VB5 in a batch process to move data in an ASCII flat file to an SQL 6.5 database running on an NT 4.0 server.

I have had some success using VB5 with a data control to move files, but I am baffled about how to do it without a data control. Also, since I am running in a 32 bit environment, do I need to do something with ODBC32?

Thanks for your help,

Kevin Ice

-- Anonymous, March 23, 1999

Answers

Kevin,

Why not have the VB5 program activate a bcp (bulk copy) process?

Eric

-- Anonymous, March 24, 1999