Post reply

any tool or method available to import this file to table.

  • December 20, 2006 at 9:25 am

    #153350

    "PATIENTID" "PATIENTIDNAME" "BILLINGHC" "BILLINGHCNAME" "CASES" "BILLINGHCPCS" "DISCHARGEDATE" "PRIMARYAPCCODE"

    "40000044" "aC E, AT " " " "NO BILL HCPCS " 1 0 "07/28/2005 " " "

    "40000051" "EFT,JODI " " " "NO BILL HCPCS " 1 0 "07/28/2005 " " "

    "40000069" "EDDFF ,EVAN " "83615" "LACTATE (LD) (LDH) ENZYME " 1 1 "07/28/2005 " " "

    "40000066" "OFF ,aEVAN " "83735" "ASSAY OF MAGNESIUM " 1 1 "07/28/2005 " " "

     

    Any way without coding and read the file line by line to import the above file to sql table. Thanks.

  • December 20, 2006 at 9:38 am

    #679155

    What is the format ? What's between each field ? A TAB character ?

  • December 20, 2006 at 9:46 am

    #679161

    it is not tab. While I tried to open as tab in excel and it also have more than 65538 record. excel will not open properly, too. Between " ". there are space.

  • December 20, 2006 at 9:53 am

    #679165

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

  • December 21, 2006 at 7:28 am

    #679414

    Without coding... I have done it before writing a Clipper program to parse the file, of course I was importing into Clipper also.

    I also used macros in text/programming editors, QEdit comes to mind to insert a comma between each "" or " "

    Other than that, I would start looking at the BCP delimiter definitions so see if I could make it work.

  • December 21, 2006 at 8:11 am

    #679437

    Hi Jhon ,

    Did you ever tried to Import such file using DTS/Wizard ?

    Please forward it to me so i can provide to you the exact tips....

    My mail address is :

    mailgupta_amit@yahoo.com

    Thanks..

    Amit Gupta.

    SQL SERVER MVP.

    /* Problem makes man perfect... Do remember it ? */

  • December 21, 2006 at 2:54 pm

    #679573

    Why not post them here so we can all learn something?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 22, 2006 at 7:10 am

    #679704

    Hi Jeff ,

    You are saying true and i will share it to all of you but before it i have to see what is exact problem so that i can give some tips & ticks!!!1

     

    Thanks...

    Amit Gupta

    SQL SERVER MVP

    /* Problem makes man perfect */

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply