Hi, Tuesday, January 20, 2004, 1:24:46 PM, you wrote: TT> Hi,
TT> Ok, I know I've already spoken blasphemy ... but hear me out. I have a TT> client who wants to move her real estate site from a local ISP to a TT> somewhat decent service. Currently her site is all in Access/ASP - since I TT> know not of that world, I'm converting it to MySQL/PHP. The person they TT> had before I'm told either took the database file they're currently using TT> from a friends job, or some manual somewhere, so its not setup as well as TT> it could be, so I've re-created the tables in MySQL to function a little TT> better. TT> I've used most of the same names from the Access file, but a few things TT> have had to be changed - its not a huge database, about 200 entries with TT> about 40 rows each, but I'd rather not cut and paste all that in - I've TT> tried exporting to CVS ... but its quite a jumbled mess, so the next best TT> thing I thought would be to write a script to do the work for me. TT> I'm guessing its just a matter of connecting to Access, and going query by TT> query through its database, pulling the fields I want then inserting them TT> into MySQL and looping through the process once again. TT> Now, the question is - how to connect PHP to MS Access? I've done some TT> searching on Google - most pages say "wow, good luck with that" or TT> something similar - any thoughts? I'm sure someone has had to do this TT> before - am I on the right track or should I be looking elsewhere? TT> Thanks TT> -Tim Probably the simplest way is to install the mysql odbc driver in windows then just export from access, it should create the table automatically and you might just have to cleanup the types afterwards. -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
