Need Help With A Database

Hi

I have a shop and instead of inputting one by one i want to put them in a excel spreadsheet and enter it in but i have no idea does anyone know how i can do this im sure theres some brainy people out there.

Thankyou
Tevv

 

I think you need to explain better what you want to do

 

Indeed it would be better, you would need to translate the spreadsheet into another format to put into a database.
For example you could save the spreadsheet in CSV format and knock up a quick php script to install the data into appropriate fields of your database.
This is assuming you are talking about a web based database, as Shauni has already stated, you need to explain exactly what you are trying to achieve with this.

 

Take a look at Excel related tools at http://www.dbconvert.com/convert-excel-to-mysql-pro.php

 

do you want to import the datas from an excel sheet to your database? i am sorry your requirement is not so clear...please confirm if this issue still exisists