Hi ,I have an .CSV file , i want to fetch entire data from that file . After that I need to pass these value to another database through Insert statement .
can anyone suggest me how to do this…
Subject: How to fetch data from .CSV file and run an Insert Query to another database
Lotus Enterprise Integrator can do this. It has connector for CSV text file, and for ODBC connection(since you mentioned “insert”).If your usage is high, like daily upload of CSV file, consider LEI.
If you like to program it yourself, that’s possible too. Read the file line by line. Use string operations in Lotus script/Java to separate different fields in a line. And things could get a little complicated when comma or double quotes also are part of field values.
For writing to ODBC data sources you could use LCConnection class.
Regards
Litty Joseph