Database Conversion.

**cavedude** · #1 05-20-2005, 08:24 AM

Ahhh I see ease of use. In that case I'm sure some people could use it. I would post it up. There is never anything wrong with sharing work.

**WildcardX** · #2 05-24-2005, 05:52 AM

Not a bad idea... MySql Control Center isn't supported any longer and is not getting developed past what exists today, so Access isn't a bad idea I guess.

**Doodman** · #3 05-24-2005, 06:30 AM

Why not just install the mysql odbc drivers and then use the real database from access?

Seems a lot simpler to me.

http://dev.mysql.com/downloads/connector/odbc/3.51.html

solid11 · #4 05-24-2005, 06:53 AM

A little help on this one Doodman. So I installed the drivers, how do you access the DB? Just open up access and go to the data folder of mysql? Which didn't work for me. No files seem compatible.

I use mysql-front now, but I'm willing to try something new if it will help find certain fields faster. Any help on using this would be great. Just need to know the steps to access the DB from access. Thanks.

sdabbs65 · #5 05-25-2005, 05:01 AM

Quote:

Originally Posted by solid11

A little help on this one Doodman. So I installed the drivers, how do you access the DB? Just open up access and go to the data folder of mysql? Which didn't work for me. No files seem compatible.

I use mysql-front now, but I'm willing to try something new if it will help find certain fields faster. Any help on using this would be great. Just need to know the steps to access the DB from access. Thanks.

The way I do it is I have a converter that converts the files from SQL to a excel.mdb file and when im done....
change it back to a SQL file useing the same converter.

solid11 · #6 05-25-2005, 01:20 PM

I don't suppose I can get my hands on this converter or explain how it's done could I?.....(beg,plead,grovel)

sdabbs65 · #7 05-25-2005, 11:45 PM

Quote:

Originally Posted by solid11

I don't suppose I can get my hands on this converter or explain how it's done could I?.....(beg,plead,grovel)

Well you could if you want to spend 40 bucks.
you can find it here.
http://www.softguru.net/products.htm

I will be releaseing the files on my website as one big database and
also each table seperately soon as im done revamping my board.
but im working on setting up a phpbb/nuke board atm so I have put this project on hold for a few weeks since it's not really needed.