Jump to content

Will phpMyAdmin compile a dynamic database for me if I import .csv's from xl?


kigroy

Recommended Posts

I created the database to look like this (brief snippet):

 

Imagine each value between commas to be column headers.

 

SS1 (Spreadsheet 1):

userID, relLocation, relHaircolor, relEyeColor, Name, Height

 

SS2

relLocation, Locations

 

SS3

reluserID, Haircolor

 

SS4

reluserID, Eyecolor

 

Is it relatively easy to do? (to gather knowledge required to do it and to actually do it can be done in a week)?  I have a full time job that is not related to what I'm doing on the side therefore by done in a week I mean the nights and weekend. 

 

BTW, I'm a noob to databases and php and mysql therefore assume I know nothing.

 

Thanks!

 

It is quite hard to tell you whether you can do something in a certain time frame.  We don't know you, don't know your skills and don't know how fast you learn.  You may want to look at scripts like http://www.codewalkers.com/c/a/Database-Code/PHP-CSV-Importer-20/ to get you started.   

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.