Am I on the right path?

[kigroy]

Hi. 

 

This is my goal:

I've created a dynamic "datbase" in excel.  I use quotes around database because at this point it is only multiple spreadsheets set up like a dynamic database.  I want to ingrate the table into my website so users can access the information.  I want users to be able to query the database to find out all the information for a particular entry ID or find all the entry ID's that match specific values or a range of values.  Or based on a profile they setup in my forum, it will return results for them about the options they have?

 

This is what I know:

I use Dreamweaver 8 for designing my webpage.  The only php experience I have is installing phpBB3 into my webpage and converting a phpBB2 forum to phpBB3.  Beyond that I know nothing about php.

 

My website host has:

MySQL Server, phpMyAdmin, pgSQL Server, phpPGAdmin (that's the tools they list under databases)

 

My general outline of what I'm going to do:

1. transform excel sheet to MySQL database (need to find out how to do this)

2. integrate into website.

 

Clearly there is a lot to fill in, but what I'm wondering is:

1. Am I heading down the right path?

2. What software is available to make my life easier?

3. where should I start?

 

Thanks!

 

 

[mrdamien]

My general outline of what I'm going to do:

1. transform excel sheet to MySQL database (need to find out how to do this) / 3. where should I start?

Export your excel data as a CSV file.

Create your database with phpmyadmin to match your excel file.

2. What software is available to make my life easier?

Use phpmyadmins import feature to copy your data from the exported CSV file to your database.

Clearly there is a lot to fill in, but what I'm wondering is:

1. Am I heading down the right path?

Yeah I guess you are.

[kigroy]

Thanks for the reply!

 

I will give it a try. 

[fanfavorite]

You could do it that way or get a program called navicat, which will convert lots of different formats including xls and upload to your mysql.  I like this program because I often have to convert access to mysql and it does it quick and painless.