Rank: Newbie
Joined: 9/1/2014 Posts: 1
|
Dear All,
We are using Altova 2014 64 bits on a Windows 8.1 running MsAccess 2013 files .accdb 64 bits on a 32 GB Ram laptop.
The purpose is to move table details 802.000 records / 40 Fields from one table to another. Table A has been uploaded from Excel 2013 by Altova Mapforce OK Table B to be feeded from Table A by Altova provides error message : Transformation - error in database sql-excecution:INSERT INTO... Reason: cannot open database ".It may not be a database that your application recognizes or the file may be corrupt.
The number of records processed before the error message appears varies from 70 upto 302.000.
The connection to the Access table is done as ADO. We tested with ODBC also, but got same error message.
Can you please help? Thanks in advance. Herman Sarnat2014 attached the following image(s):
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
We can only guess, but most probably you are running into ACCDB files 2GB limit
|