Jump to content
xisto Community
Sign in to follow this  
Kian Mike

Mysql Database Entry By Excel Sheets

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.