• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access Database 2007 Export Tables via ODBC Database "Overflow" problem?

 
bilal haider
Ranch Hand
Posts: 47
Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I can export a table by clicking on table ->export -> ODBC database. and selecting data source connection which in my case is oracle data source. Export was runing fine .

I have a list of 100 ms access files,
files contains Order table and OrderDetail Table
2 file are successfully imported using the above methd,
I get the "Overflow Error when i selected "OrderDetail" Table -> ->export -> ODBC database. and selecting data source connection which in my case is oracle data source.

What could be cause and its solution?
table click.png
[Thumbnail for table click.png]
 
Jan Cumps
Bartender
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you get additional info in the "Overflow Error"?
 
bilal haider
Ranch Hand
Posts: 47
Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jan Cumps! Thank you for the time. I did not get additional info in the error message . I get the name of " Application" of ms access from which i am importing the table..... Like "Order Management System", on the title of message box.....

I can export the same table in another ms access file . But table from some files are throwing "Overflow" error message.....

Scenerio

MS1.accdb Tables Order, OrderDetail <<success>>
MS2.accdb Tables Order, OrderDetail <<success>>
MS3.accdb Tables Order, OrderDetail << Export Error>>
MS4.accdb Tables Order, OrderDetail <<success>>
MS5.accdb Tables Order, OrderDetail << Export Error>>
MS6.accdb Tables Order, OrderDetail <<success>>
...
...
...
...
ms100.mdb ables Order, OrderDetail


What should i do? Is the data in the table is faulty? the table that are not successfuly exported?
 
bilal haider
Ranch Hand
Posts: 47
Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry for late reply..... I identified the problem by using MS Office 2003 . I created a link table to Oracle in MS Office 2003, Then copy and paste values on the linked table in MS Office 2003,. The rows which were having wrong attribute values were pasted to paste error table. By inspecting the rows it was a column with date like 9/11/199 ... Last section that is 199 was causing overflow problem while exporting the table in Office2007.... So successfully migrated legacy data...
 
Jan Cumps
Bartender
Posts: 2599
12
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for posting the solution, Bilal !
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic