Importing To Access

source1Tamer · Post by **source1Tamer** » Fri Nov 29, 2002 1:32 pm

I successfully imported a texis table to an MS Access database, but for BLOB fields in texis table, it's imported as OLE Object in access. how could I get the data for this Blob or OleDB datatypes?

thanks in advance.

Post by **John** » Fri Nov 29, 2002 4:54 pm

Access should see it as a LONGVARBINARY. You would need to check with Access as to how to do what you want with it.

source1Tamer · Post by **source1Tamer** » Mon Dec 02, 2002 10:33 am

thanks, I used the varchar(65000) instead of blob.