| |
The PHP developers network
619 hits
Mar 09, 2004 5:35 pm |
|
re: Getting MS Access 97 data programatically into a PHP/MySQL project |
A Gibson
| |
Access is to be a database only, not a GUI front end.
The end users will not have the Access front end.
Some accounting program with no source code dumps the new data into the Access database.
The PHP program i am writing needs to extract the data, programatically from Access database.
The end users will be running the program and thus extracting new data every week.
I thought about the CSV export and import, but the end users will not have the Access GUI front end.
So I still need some Access interface routines from PHP or something that end users can do.
Thanks
Alan..................
Joe Wrote:
>What you want to do is to export the Access data as a CSV file, then use phpMyAdmin to import the CSV file. It's pretty straightforward.
>
>I can't think that Access 97 could be used as an interface to MySQL -- it may be possible, but probably will be clunky.
>
>Try phpMyAdmin
>
>Best regards,
>
>Joe Private Reply to A Gibson (new win) |
|