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.

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.

thanks ifor the tip.

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)