Jeroen Hartsuiker
October 26th, 1998, 07:53 AM
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
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