Re: [SLUG] Read MS Access files on Linux (using php?)

[Kyle <kl@xxxxxxxxxxx>]

FWIW,

and it's not the answer you're looking for, but;

if you're only reading via ODBC, I've never experienced any problem with 
data loss. Provided you find the right version ODBC driver to match the 
right version Access .mdb file. They've changed format a couple of times 
over the years, so you need to be aware on that front.
Assuming you know the version of Access, the obvious question would be 
can you not ask the same govt. dept. to give you access to an MS box to 
enable you to simply 'export' the info in all tables to .csv, from which 
you can work on it in your chosen format?

------------------------------------------------------------------------
Kind Regards

Kyle



Peter Rundle wrote:
> So I need to read these files and extract the data from them. Google 
> tells me that you can access this data using an ODBC driver but then 
> Google also tells me that this is likely to end in a horror story. 
> However, I believe that I've seen/read somewhere that there are tools 
> available that allow me to open and read the files directly as raw 
> data files.