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


darasen

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.


darkken

you can use phpMyAdmin too if you have php enabled server


iGuest

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


VIEW DESKTOP VERSION REGISTERGET FREE HOSTING

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.