Jump to content

Excel to MySQL


timmah1

Recommended Posts

What is the best way to import an excel worksheet into a MySQL database?

 

I save it as Tab Delimited, I get errors, I save it as a Comma delimited, I get errors.

I did run the query once, but the only thing that was entered was the id (because it's auto increment)

 

How do I get this database of 349 items into the database without manually typing each one in?

 

Thanks in advance

Link to comment
https://forums.phpfreaks.com/topic/86257-excel-to-mysql/
Share on other sites

Hello

 

I used a program called SQLyog which will allow you to inport a CVS file. Sorry I cannot be more specific but it was some time ago. I know it worked with an Excel sheet I needed to get into mysql, you can download it for free at some sites.

 

I also remember that when I searched there were other programs that will do what you require.

 

Regards

Link to comment
https://forums.phpfreaks.com/topic/86257-excel-to-mysql/#findComment-440856
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.