vhmau
Newbie
Joined: 22 Sep 2005
Posts: 3
|
 Posted: Jun 12th, 2006 03:51 AM Post subject: sql statement don't run in MS Sql server |
 |
|
Hi everyone
I have this vb6 code:
strSql = "select * into [text; FMT=Delimited; HDR=Yes; Database=c:\temp].[TC.txt] from Employees"
con.Execute strSql
if my con connects to MS access database, this bulk of code run ok. If my con connects to MS Sql server 2000 database, this bulk of code returns error.
Can anyone shows me how to do in MS Sql server 2000 to get the same result as when running this code with MS access database ?.
Thanks. |
|
