Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Data type 130 error importing data from Access

Author  Topic 

kriseide
Starting Member

2 Posts

Posted - 2010-12-07 : 08:52:17
Hi all!

I have this trouble importing an Access database in SQL server 2008: the automatic import tool fails because of a text field in an Access table that it isn't recognized as text and it is associated to a strange "130" data type (that the tool cannot handle!).
Other tables in the database Access contain text fields with (seemingly) the same properties and they are imported without any error

Have anyone seen this error or know anything about it? I'm searching the solution everywhere...

Thank you for any advice!
   

- Advertisement -