RDO DataType query.

A colleague is trying to get some SQL Server data into MS Access, and is querying the table from a VB program.

She opens an rdoconnection to an SQLServer database. When testing recordset.rdocolumns("fieldName").type it gives -9 as the value. This does not relate to any of VB's listed RDO connection types. It also shows the rdocolumns("fieldName").size as being twice what the database shows when viewed through Microsoft Access. What is this datatype?

Any ideas?

I've found various lists for datatype eNums for ADO, but nothing on RDO (as it's obviously obsolete). Anyone out there got any ideas (other than "use something else")?

Thanks in advance

Chris.

export the data from sql server using dts

call the dts from the apps using dts run utility

or

use ado

or use replication