HOME       >>       Programming

Mysql Database Entry By Excel Sheets

Kian Mike

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


How to Link excel table permanently to mysql database for regular data updatesMysql Database Entry By Excel Sheets

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


Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.