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.
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
