How can I import an ASCII comma-separated file into a SQL Server table using Visual Basic VBSQL.OCX?


I already know and read the helpfile VBSQL.HLP.


In MS-Dos I use the following statement:


>BCP SQLServerDatabase..SQLServerTable IN NameTextFile /U UserName /P Password /S ServerName /c /t ; /r \r\n


This works fine on ASCII files formatted like:


aaa;bbb;123;fde;34.5;ree <Return><NewLine>

vvv;rrr;543;eqg;65.4;dws <Return><NewLine>


Is there a VBSQL equivalent for /c /t ; /r \r\n in one line, without specifying the format of each column separately..?



Grace & Peace

From Jeroen Hartsuiker