Access 2000 datatype mangling...er...mapping

Trying to export tables from Access 2000 to Oracle 8.0.5 (Solaris).

Numeric datatypes get scrambled. The left column below are Access 2000 datatypes and the right column are what end up in Oracle after an export.

 Access 2000 Oracle

 Number/Autonumber		VARCHAR2(2)
 Number/Byte			not supported
 Number/Integer 		VARCHAR2(1)
 Number/Long Integer		VARCHAR2(2)
 Number/Single  		VARCHAR2(2)
 Number/Double  		VARCHAR2(4)
 Number/Replication ID  	RAW(16)
 Number/Decimal (18,0)  	NUMBER(18)
 Text (50)			VARCHAR2(50)
 Memo				CLOB
 Hyperlink			CLOB
 Date/Time			DATE
 Currency			VARCHAR2(4)
 Yes/No 			not supported

I've tried various versions of ODBC drivers from Oracle, Microsoft and Merant with only minor variations in the result. (The MS driver translates Memo and Hyperlink to LONG instead of CLOB.)

For the most part, exports work fine from Access 97, and of course they work fine when the target is MS SQL server. Too bad the whole place here has boldly marched on to Office 2000.

When are the folks in Redmond going to realize that adding 492 new features to a product is only progress if the total number of *working* features in the product also goes up....or at least doesn't drop.

-john Received on Tue Oct 26 1999 - 20:10:03 CDT