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
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.
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