how to import such text file to sql server 1

[yan19454]

PATIENTID" "PATIENTIDNAME" "BILLINGHC" "BILLINGHCNAME" "CASES" "BILLINGHCPCS" "DISCHARGEDATE" "PRIMARYAPCCODE"
"12048583" "aCCcG ,JEAN " " " "NO BILL HCPCS " 1 0 "06/30/2006 " " "
"40000002" "aCE ,eiii " " " "NO BILL HCPCS " 1 0 "07/28/2005 " " "
"40000069" "EFTOFF ,Rboert " "83615" "LACTATE (LD) (LDH) ENZYME " 1 1 "07/28/2005 " " "
"40000069" "TESTA ,JUNK1 " "83735" "ASSAY OF MAGNESIUM " 1 1 "07/28/2005 " " "

How to import such file to the sql server ? Thanks.

I hope I do not need to look through the whole file to read line by line ?

Thx.

 

[AlexCuse]

Is this a space-delimited text file???

I am not sure there is an option to import such a file, and I am away from a computer I can check on. My first thought is you could use VBScript toreplace " " with ", ", but then you run into troubles with the spaces within data. And also with what appears to be stray quotes.

I don't envy your predicament one bit. Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[yan19454]

Thx. Thanks. I use space as delimite and text qualifiler as ". it solve the problem.

 

[AlexCuse]

Ah I guess that is an option then. Glad it worked!

Alex

Ignorance of certain subjects is a great part of wisdom

 

[triggerhappy]

Dude...if you are still working on this..

just one thing...make sure you RTRIM your fields when you import them...as they seem to have added space

Have had some probs in the past with the same...especially querying the data with added space in the values...

Hope its helpful!
-------------

TriggerHappy