#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    mozambique
    Posts
    4
    Rep Power
    0

    Question convert text to sql


    i eve a text file from telephone company and i eve been ask to convert that text file to sql database so it can be manipulated
    becouse my boss wants to control whiche numbers are the most dilled (in a month,week.ect),who`s using the phone most of the time so tht he can calcula the productivity of eche one.

    plese tell me how can i convert thet text file to sql,geve alternatives if possible.
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,648
    Rep Power
    4248
    You can use the Import Wizard from Enterprise Manager to import a text file. Alternatively, you can also use the bcp command line utility. Consult your Books Online for "Data Transformation Services" and "bcp" for more information on how to use them.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    mozambique
    Posts
    4
    Rep Power
    0
    thanks ifor the tip.
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Manchester, UK
    Posts
    23
    Rep Power
    0
    If you have problems with the quality of the data you may want to have some more control over the process. If you load the text file into Excel first you can fix any anomalies before loading it all into the database.

    In Excel you can use the SQL*XL addin to load data from Excel into the database. If you hit errors, SQL*XL will leave the error description next to the row to it is easy to spot and fix errors.

    Have a look at SQL*XL at www.oraxcel.com

    Any questions, just ask!

    Gerrit-Jan Linker
    www.oraxcel.com (SQL*XL)

IMN logo majestic logo threadwatch logo seochat tools logo