Import excel data into mysql database [Solved/Closed]

Question

Import excel data into mysql database [Solved/Closed]

Report

nischala - Mar 12, 2010 at 04:17 AM
Er.mayank khandelwal - Jan 5, 2011 at 03:41 AM

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

Import excel data into mysql database
Possible to import pdf data onlin into excel? ✓ - Forum - PDF
Import webpage data into Excel spreadsheet ✓ - Forum - Excel
Excel data validation list from table multiple columns - How-To - Excel
Multiple if statements in excel data validation ✓ - Forum - Excel
Using multiple if functions with data validation - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2010-03-12T14:48:50-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Mar 12, 2010 at 02:48 PM

You can open a connection to excel and then read from the recordset would be one way.

Report

Yuvan
Apr 10, 2010 at 08:39 PM

How to do that..?? Pls explain briefly.. Thank you.

Report

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
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

Import excel data into mysql database [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!