Jump to content

XLS => MySql


Lamez

Recommended Posts

Is there a way to convert my xls spreadsheet into my DB?

 

Should I put its contents into a text file, and have certain delimas?

 

like

 

Atlantic Coast Conference

-Team A

-Team B

:::----

Big 12

-Team A

-Team B

 

...

 

and so on.

 

If so, how would I write a piece of code that would take the words like "Big 12" into a new table, then the words with - like "-Team A" into a row?

 

Thanks for the help, and suggestions!

Link to comment
https://forums.phpfreaks.com/topic/126381-xls-mysql/
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.