read .csv and write in DB

Ranch Hand

Posts: 146

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,
Am looking for a free software which has to read the .csv file and populate data in the table in DB.
Does anyone can help me out regarding this.
Thanks
Cheers
Jowsaki

Gregg Bolinger

Ranch Hand

Posts: 15304

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moving to General Computing...

Adrian Yan

Ranch Hand

Posts: 688

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

what database do you use? Most databases nowadays should support convert csv into database automatically.

Richard Rodger

Author

Posts: 31

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This component will help with the csv side of things: http://ostermiller.org/utils/CSV.html (it's free) and then you can just create the SQl statements from the parsed data.

Richard Rodger<br /><a href="http://www.ricebridge.com" target="_blank" rel="nofollow">http://www.ricebridge.com</a>;

You'll never get away with this you overconfident blob! The most you will ever get is this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser