Set Home| Set Favorite|

WPS Office Forum

 Forgot password?
View: 3690|Reply: 2

Datasheet and Mysql connection

[ Promote this link! ]
Post time: 2014-08-27 22:27:09
| Show all posts |!read_mode!
Edited by quico2004 at 2014-08-27 22:35

Plan to include the connection of Spreadsheet to Mysql?
Trying to connect using ODBC 5.3.4 and Mysql 5.5.20 Mysqlconnector, managed to establish the connection, shows me the tables but not the fields in the database.
Any suggestions to establish the connection?


Use magic Report

Post time: 2015-04-29 09:48:42
| Show all posts
Did you get any answer about this? I also need to connect my MySQL to datasheet and would like to know how to do this. Any suggestions please?
Post time: 2016-08-19 18:09:08
| Show all posts
First, you must download the most recent Open Database Connectivity (ODBC) driver for MySQL. Next, you will  need to install the driver you just downloaded.  Double click the file to start the install process.  Once the install process is complete you will need to create a Database Source Name (DSN) to use with Excel. Refer more info from
You have to log in before you can reply Login | Register

Points Rules

Dark room|Mobile|Archiver|WPS Office   

2019-07-20 14:23 GMT+8 , !processed_in! 0.079041 !seconds!, 15 !queries! .

Powered by Discuz! X3.2

Release 20151208, © 2001-2019 Comsenz Inc.

MultiLingual version, Rev. 469, © 2009-2019

!fastreply! To Top !return_list!