Previous Topic Next Topic

Import excel data into mysql database

Solved/Closed
nischala - 12 Mar 2010 à 04:17
 Er.mayank khandelwal - 5 Jan 2011 à 03:41
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

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Mar 2010 à 14:48
You can open a connection to excel and then read from the recordset would be one way.
Yuvan
10 Apr 2010 à 20:39
How to do that..?? Pls explain briefly.. Thank you.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Apr 2010 à 20:53
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
Er.mayank khandelwal
5 Jan 2011 à 03:41
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

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses