Yes I found it!!:
http://www.cynergi.net/exportsql/
thanks you again!!
mweb
> ---------- Initial message -----------
>
> From : "Andrew Hill" <[EMAIL PROTECTED]>
> To : "mweb" <[EMAIL PROTECTED]>
> Cc : <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Date : Tue, 13 Nov 2001 11:00:05 -0500
> Subject : RE: [PHP] Access to MYSQL via ODBC?
>
> Mweb,
>
> This access to mysql conversion tool is availabe at the MySQL site - check
> the contributed software section for a couple of options.
>
> Alternatively, just run both MySQL and Access on Windows, and access it via
> ODBC.
>
> Best regards,
> Andrew Hill
> Director of Technology Evangelism
> OpenLink Software http://www.openlinksw.com
> Universal Data Access & Data Integration Technology Providers
>
> > -----Original Message-----
> > From: mweb [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 13, 2001 11:02 AM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: [PHP] Access to MYSQL via ODBC?
> >
> >
> > Andrew,
> >
> > thanks again for your lightning fast answers. However, I realize that
> > I did not explain the problem completely. Part of it is that I don't
> > have the possibility to network one Win computer and a Linux one.
> >
> > I only have either Linux or Windows, in any given moment....:-((
> > Otherwise another solution would have been to leave the access DB
> > run on the Win machine, and access it via ODBC from the Linux one
> > without MySQL at all.
> >
> > Sometime ago I heard a tool that converted offline Access files
> > to MySQL ones but can't find it again now. Is it still around? Has
> > anybody used it?
> >
> >
> > > ---------- Initial message -----------
> > >
> > > From : "Andrew Hill" <[EMAIL PROTECTED]>
> > > To : "mweb" <[EMAIL PROTECTED]>
> > > Cc : <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> > > Date : Tue, 13 Nov 2001 10:48:52 -0500
> > > Subject : RE: [PHP] Access to MYSQL via ODBC?
> > >
> > > Mweb,
> > >
> > > Same --with-iodbc, just install a different ODBC driver.
> > > Use the OpenLink Multi-Tier driver, "piggybacked" on the MS
> > Access driver.
> > >
> > > Install the Multi-Tier driver with Linux as your client, Win32 as your
> > > server, and Access as your db.
> > >
> > > Then:
> > > 1. configure a system DSN on the Win32 box using the ODBC
> > Administrator and
> > > the MS driver for Access. For the example we'll call it "foo".
> > > 2. configure a DSN on the Linux box in the odbc.ini file. ServerType =
> > > ODBC, Hostname = [win32 ip address], Database = foo.
> > > All other parameters should be self-explanatory.
> > >
> > > Connections may be verified using "odbctest" application.
> > > Be sure to use the syntax "DSN=DSN_NAME" in odbctest.
> > >
> > > Best regards,
> > > Andrew Hill
> > > Director of Technology Evangelism
> > > OpenLink Software http://www.openlinksw.com
> > > Universal Data Access & Data Integration Technology Providers
> > >
> > > > -----Original Message-----
> > > > From: mweb [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, November 13, 2001 10:45 AM
> > > > To: [EMAIL PROTECTED]
> > > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > > Subject: RE: [PHP] Access to MYSQL via ODBC?
> > > >
> > > >
> > > > GREAT, THANK YOU!
> > > >
> > > > Now the only step left is how to convert (on Linux) the MS access
> > > > database to MySQL...How?
> > > >
> > > > mweb
> > > >
> > > > > ---------- Initial message -----------
> > > > >
> > > > > From : "Andrew Hill" <[EMAIL PROTECTED]>
> > > > > To : "mweb" <[EMAIL PROTECTED]>, "phplist"
> > > > <[EMAIL PROTECTED]>, "mysqllist"
> > <[EMAIL PROTECTED]>
> > > > > Cc :
> > > > > Date : Tue, 13 Nov 2001 10:27:15 -0500
> > > > > Subject : RE: [PHP] Access to MYSQL via ODBC?
> > > > >
> > > > > Sure, this is entirely possible.
> > > > > Configure PHP --with-iodbc as per the HOWTO at
> www.iodbc.org and then
> > > > install the MyODBC driver.
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
