This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Import CDR File into Sql Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Import CDR File into Sql Database" Watch "Import CDR File into Sql Database" New topic
Author

Import CDR File into Sql Database

Madhu Kaparapu
Ranch Hand

Joined: Jul 04, 2005
Posts: 35
I am doing Billing web based project(J2EE). I have to import CDR (call detail report) Excel file into Ms Sql Database
plz help me i am new to MS Sql Database. The CDR file too large.


Regards,
Madhu Kaparapu.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31585
    
185

Madhu,
Welcome to JavaRanch!

The file is too large for what?

It's a matter of reading in the file (either as a comma delimitted file or through an Excel API like HSSF) and looping through it to put the rows in the database using JDBC.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
rocket mass heater kickstarter
 
subject: Import CDR File into Sql Database