The project that I am currently working on consists of a MySQL database that is fed data from a series of PHP scripts. Users need to be able to glean data from this database into Microsoft Access 97 in order to produce reports, etc..
I installed MyODBC to facilitate this, however Access throws a wobbly when I try to Import data from the database...it gives an ODBC error as such:
Nulled type out of range.
I've tried simplifying things down to a two field table of an Integer (as the primary key) and a Text field...I've put data into the table, and still the same error.
I'm really stuck as to what I should do, as my experience with Access/ODBC is minimal, and any help would be greatly appreciated.
Thanks,
Mike
