Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to mysql database.Thanks
Yes, you can use ADO to create an ODBC connection between an excel spreadsheet and MySQL. It may even be a bit easier to import the excel data into Access and then use the data connection and querying abilities of Access. Alternately you can export your Excel data to a CSV file and use the tools in MySQL to import the data file.
you can use phpMyAdmin too if you have php enabled server
Can Ms excel worksheet be used as a permanently linked, always on front end to a table in mysql database for data updates directly in the mysql database table? If The anwser is YES, then kindly show me how to do it:. Thanks for your co-operation.-question by K. Adjei