Extracting data from MySQL into Access
Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie
Re: Extracting data from MySQL into Access
Shortly, if you have MySQL ODBC driver installed, you can create ODBC data source and connect to this data source from Access, Excel, Open Office, Dusan Dewald Troskie napsal(a): Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Extracting data from MySQL into Access
You can set up an ODBC connection to the MySQL data base, and then use Access directly on your data base. Does that come near what you want? (You can set it up read-only.) Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Dewald Troskie [mailto:[EMAIL PROTECTED] Sent: Monday, January 15, 2007 5:39 AM To: mysql@lists.mysql.com Subject: Extracting data from MySQL into Access Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]