cfuentes
|
Posted: 04/02/2004, 9:37 PM |
|
Ok,
I did something really stupid. I just built an app using codecharge with PHP and MSACCESS. I need to deploy on a server using mySQL.
Are there any free tools that will take my access database, dump it with the table structures to a php file?
I've seen some that charge a fee that will do this, along with creating the table structure.
|
|
|
Martin
|
Posted: 04/02/2004, 11:05 PM |
|
Hello.
Go to Google and:
access to mysql
By Martin
|
|
|
PeterJ
Posts: 90
|
Posted: 04/03/2004, 8:05 AM |
|
Try www.convert-in.com
Not free but very useful
|
|
|
mick
|
Posted: 04/03/2004, 2:14 PM |
|
navcat from premium soft is a good all round tool for converting most database types . An evaluation version is available at http://www.navicat.com/
hope this helps.
|
|
|
RoyI
|
Posted: 04/03/2004, 2:31 PM |
|
You might want to have a look at AccessDump which is free.
http://www.intranet2internet.com/public/default.asp?PAG...re&DETAILS=DUMP
|
|
|
sweiss
Posts: 22
|
Posted: 04/06/2004, 6:06 AM |
|
Hi,
the easyest way is, install a ODBC-Driver for the MySQL and Export all tabels via MS Access
Stefan
|
|
|
SteveG
|
Posted: 04/14/2004, 7:40 AM |
|
I'm using MyAccess (http://www.hiden.org/myaccess) and find it works great.
- Steve
"cfuentes" <cfuentes@forum.codecharge> wrote in message
news:5406e4d8192868@news.codecharge.com...
> Ok,
> I did something really stupid. I just built an app using codecharge
with
> PHP and MSACCESS. I need to deploy on a server using mySQL.
>
> Are there any free tools that will take my access database, dump it with
the
> table structures to a php file?
>
> I've seen some that charge a fee that will do this, along with creating
the
> table structure.
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
klasch
|
Posted: 04/22/2004, 4:52 AM |
|
ODBC-Driver for the MySQL + MySql Front
http://www.mysqlfront.de
|
|
|
Ashiff
|
Posted: 04/23/2004, 5:51 AM |
|
If you believe in results and no in tedious procedure then ROYI answer is best. very simple and fruitful
http://www.intranet2internet.com/
product is access2dump and great news is, it is free
|
|
|
Gymsmoke
Posts: 3
|
Posted: 04/27/2004, 10:12 AM |
|
sweiss said it best... also, if you are a licensed user (I take it you mean Microsoft SQL*SERVER and not mySQL), there is an object copy in the SQLAdmin which allows you to directly import from Access with a lot of options. If you are using mySQL, then just setup the odbc driver and export. Also, EMS makes a data export/import tool which you can try for ree (although it is limited in the number of records), but it is quite reasonably priced and works great.
_________________
Losers always whine about their best...
Winners go home with the prom queen. |
|
|