最佳解答者
Question about Bulk Insert on MSSQL

問題
-
Hi
I have some csv files that I want to import to MS SQL 2000
The csv file contain text and number, which is exported from another SQL database.
They have use speech mark as Text quantifier. E.g. "abc"
I am wondering if I can set a text quantifier on the BULK Insert statement to read any thing contains speech mark as a text, and the other as int? I have read the document on Microsoft website, it does not seem to have a text quantifier options.
Many thanks
Chi
解答
所有回覆
-
Hi Rmiao
Sorry to mis-leading you. The csv file is export from another SQL database, that is generated by an other company. I think they are generated by using VB 6 Application.
Here is example of the data.
"CustomerCode","Prefix","PhoneNumber","StartTime","Duration",
"CA1000","HK","01234512321",20/07/2007 20:58:08,2
"FX1240","HK","01234512321",16/07/2007 09:50:08,66
I am wondering if it is possible to import this file into SQL Server and remove the "Speech mark" if they are String?
Thanks very much for your help.
Chi