Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes MS Access Database 2007 Export Tables via ODBC Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS Access Database 2007 Export Tables via ODBC Database "Overflow" problem?" Watch "MS Access Database 2007 Export Tables via ODBC Database "Overflow" problem?" New topic
Author

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

bilal haider
Ranch Hand

Joined: Feb 08, 2011
Posts: 47

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?


[Thumbnail for table click.png]

Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2499
    
    8

Did you get additional info in the "Overflow Error"?


OCUP UML fundamental and ITIL foundation
youtube channel
bilal haider
Ranch Hand

Joined: Feb 08, 2011
Posts: 47

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

Joined: Feb 08, 2011
Posts: 47

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

Joined: Dec 20, 2006
Posts: 2499
    
    8

Thank you for posting the solution, Bilal !
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MS Access Database 2007 Export Tables via ODBC Database "Overflow" problem?