Menu
Ask a question Report

Import excel data into mysql database [Solved/Closed]

- Mar 12, 2010 at 04:17 AM - Latest reply:  Er.mayank khandelwal
- Jan 5, 2011 at 03:41 AM
Excel Ask a question Report
Hello,


This is Nischala .Can any one suggest me wheather we can import excel sheet data into mysql database using .net application(vb.net or asp.net).



thanks in advance
See more 

4 replies

Best answer
Report Respond to rizvisa1
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 - Mar 12, 2010 at 02:48 PM
1
Thank you
You can open a connection to excel and then read from the recordset would be one way.

Thank you, rizvisa1 1

Something to say? Add comment

CCM has helped 1651 users this month

Report
Yuvan - Apr 10, 2010 at 08:39 PM
How to do that..?? Pls explain briefly.. Thank you.
Report
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 - Apr 10, 2010 at 08:53 PM
Sorry I had misread the question then. That would have been true if data was to pulled into excel, To insert data into db, just read the value and create insert statements and execute
Report
Er.mayank khandelwal - Jan 5, 2011 at 03:41 AM
In this below query you can import data in mysql database

LOAD DATA LOCAL INFILE 'C:\\wamp\\tmp\\php89.tmp' INTO TABLE 'collection' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'# Affected rows: 2599
Ask a question