SEO

#1 (**permalink**) 02-28-2008, 07:55 AM

I need to export a "MYSQL" database to either a "dbf" format or a Microsoft
Access readable format. I have a command line base set of instructions,
but it says to export the ".sql" file, which does not exist, as a "comma
delinated" file. So, how do you do it?

I have looked at "gui's" and know they probably work, but so far have not
been able to get one to work. Rather than being a simple, "what .sql
database do you want to export to what format?' I have to be an expert in
Linux/unix operating systems to even get the thing set up. Yes, they were
free, but the important thing is workability.

Thanks

Deb

#2 (**permalink**) 02-28-2008, 07:55 AM

I love all the bugs in mysql, why arent you converting access to mysql.

this product works well but you will find all tables get converted into
individual MDB file
http://www.navicat.com/

this product says it will do 5 records for each table (wouldn't be to much
to write export routine for each table)
http://www.convert-in.com/sql2acc.htm

which ever one of these you choose you may loose couple of hours
'converting' but otherwise buy one.

#3 (**permalink**) 02-28-2008, 07:55 AM

Dr. Deb wrote:

> I need to export a "MYSQL" database to either a "dbf" format or a
> Microsoft
> Access readable format. I have a command line base set of instructions,
> but it says to export the ".sql" file, which does not exist, as a "comma
> delinated" file. So, how do you do it?
>
> I have looked at "gui's" and know they probably work, but so far have not
> been able to get one to work. Rather than being a simple, "what .sql
> database do you want to export to what format?' I have to be an expert in
> Linux/unix operating systems to even get the thing set up. Yes, they were
> free, but the important thing is workability.
>
> Thanks
>
> Deb

The reason is that the guy who needs the file is running Access and does not
want to change. Egro, I need to get it into a form he can read.

Deb

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

SEO

Export