SEO

#1 (**permalink**) 02-28-2008, 05:36 AM

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

#2 (**permalink**) 02-28-2008, 05:36 AM

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
>
>
>
>

#3 (**permalink**) 02-28-2008, 05:36 AM

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:dewald@globalimage.co.za]
> 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
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode