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
|
