 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Getting Started / July 2006CSV file
I have an excel file with 200 records , which i converted in to a .csv file. Now, I want to write an insert/import script so that I can insert all those records into the database at once. How do I do that? Hi ronfusion You want to just import the data inside the database right.. So you can use the Import /Exprot to database in the SQL or if you are using the oracle then you have the tool called SQL Loader with the help of these tools you can import or export the data's from the database. regards Anbu How do you write that import/export to the database.. Can you show me an example? Like I have this csv as 1, test, car, Yes, No 2, test1, truck, No, Yes hi ronfusion, You can use the cfx_excel2query tag for the delimtation. there is inbuilt funtionality in the microsoft SQL when you import export the data throught there tool you will be asked to mention the delimiter also you can select the delimter as the comma seprator from the tool option. if you have the microsoft Sql you could see the option for import /export. just click on it you will asked for the file format metion it as the csv and click next you will see another screen asking fort he same thing where you can mention your database. then click next you will listed with the list of table you can select the table to insert and in the next step you would be asked to provide the delimiter. after that click finish you csv data will be imported to the database table which you have selected. regards Anbu Hi, Give a try to FREE cfx_text2query from emerle.net (its excelent tag!) : java-based CFX tag for parsing delimited text files and converting them to ColdFusion queries. This is particularly useful for CSV (comma-separated) files which are commonly used for data imports. or cfx_excel2query ($$) a java-based custom tag for importing from excel without the need for com interaction (or excel on your server)! http://www.emerle.net/programming/ Cheers Kim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.