Thanks Harun,
I could csv-export the table correctly, so no corruption apparently. I found a registry key called "LocksPerPage" that belongs to MS Office, after increasing it I was able to translate MSAcces Currency type to Integer successfully. Exporting through ODBC right after that was also successful. However that doesn't ring me a bell on how one can automagically export an MSAccess table through postgres odbc when having a column with Currency data type.
Thanks Richard for your suggestion.
Regards,
Albert2011/9/12 aihtdikh
<aihtdikh@gmail.com> Hi Albert,
Is Access able to do anything with the data in that column?
For example, exporting the data to a .csv file, or even just creating another table with a copy of the same data.
If mdbtools can read the data, but MSAccess itself cannot, I would suspect some sort of corruption in the mdb.
Regards,
Harun
On 12/09/2011 08:37, albert wrote:
The problem is how can I get MSAccess translate that column type properly?
Why would I need to change that manually? I have a bunch of columns of such type.
The process just stops half way through there's no way I can export that table.
Additionally, I have tried to change that column type from within access to all numeric variants, even to text type,
prior to exporting it. Access stops half way through complaining about "not enough memory", which doesn't make sense.
The table has over 620.000 rows.