import excel to mysql

By arjun_goud ·
how to import excel to mysql in c#, using windows application.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

first things first

by ThumbsUp2 In reply to import excel to mysql

First, export the excel spreadsheet to a comma separated text file (DOS CSV). Then use Notepad to open the file and make sure there are no quotes (single ' or double ") in the file, since those will mess up the import into MySQL. Don't mess with the lines otherwise.

After that, you need to create SQL statements to import the data (insert) into the database table.

Related Discussions

Related Forums