Question Locked
import excel to mysql
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how to import excel to mysql in c#, using windows application.
Software
by arjun_goud Accepted solution
by thumbsup2 Accepted solution
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.
This discussion is closed to new replies.
Sort by Trending