Hi, I did actually download DBTools and i think its' an excellent software. It's running perfect on my system too. Just a couple of things i'd like to ask you, since you have already used this and i'm fairly new to this...
You see, my MySQL server/database is on a web server, for a online website. Now how do i connect the DBTools on my system to the Web Server on the Internet, and then to the database on the website?? Once i'm able to connect to that, then i think it should not be a problem to import the Data from the MS Access table into the MySQL table on the internet. Really appreciate your help... Thanks! T. Edison jr. --- Steven Dowd <[EMAIL PROTECTED]> wrote: > > > you should try this program , DBTools > > http://www.dbtools.com.br/ > > a.. Import Structure and Data from others Databases > (MS Access, MS FoxPro, > Clipper, Dbase, Paradox, Text Files and ODBC Data > sources) > > a.. Export the database/table contents to SQL, Text, > HTML or XML documents. You > can dump it directly by using the Dump Data or you > can export your results (this > includes other formats) > > a.. You don't need to have MySQL server installed in > a WIN32 platform. DBTools > can connect to MySQL wherever you have your server > installed, using TCP/IP and > MySQL C API. > > I use this constantly to transfer direct from access > / excell into mysql. its > isnt the answer for you if you want to do it > completly with php, but it gets you > to the basic area, and transfers the data.. > > there is at www.hotscripts.com a php access>mysql > converter, i tried it last > year, but found it very buggy. cannot remember what > it was called > > steven dowd > > > ----- Original Message ----- > From: "Thomas Edison Jr." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 25, 2002 11:31 AM > Subject: [PHP] MS Access data => mySQL database > > > > Can anyone tell me how to convert/send data stored > in > > an MS Access database to a mySQL table through > PHP?? > > > > T. Edison Jr. > > > > > > > > ===== > > Rahul S. Johari (Director) > > ****************************************** > > Abraxas Technologies Inc. > > Homepage : http://www.abraxastech.com > > Email : [EMAIL PROTECTED] > > Tel : 91-4546512/4522124 > > ******************************************* > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Movies - coverage of the 74th Academy > Awards® > > http://movies.yahoo.com/ > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > > ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
