sheardben — 2012-01-17T12:23:10-05:00 — #1
I would like to offer support on my site for importing certain data from MDB files that users can upload. They aren't exactly Access files, but this particular program that users are exporting from generates a Jet database file with a different extension.
I've been Googling a lot a only found the PHP MDBTools extension which might have done the trick, but my host doesn't support that extension.
Does anyone know of any other way of potentially doing this?
jv1 — 2012-01-17T13:10:15-05:00 — #2
Sounds like you are on a shared host. You might still want to entertain the possibility of mdbtools, assuming that you are on Linux.
MDB Tools lets you export tables from an MDB file in to CSV files, which you can then easily manipulate with PHP.
pcspectra — 2012-01-17T13:45:06-05:00 — #3
I have been working on porting a legacy application built in Access. Not sure if this is applicable but you can setup a MySQL ODBC connection in Access and export tables into MySQL or whatever RDBMS you are using. MySQL likely will need be configured to allow remote connections.
sheardben — 2012-01-18T04:04:09-05:00 — #4
Yes I am on a shared host, and they say they can't load MDBTools on the servers, so I'm not sure if that is going to be a possibility, but I'm going to keep looking around.
@PCSpectra, sounds interesting, but I don't think that would be applicable.