Hi:

I have a MS Access database which has a column defined as a GUID. When I ask the DatabaseMetaData.getColumns() for the type name, it returns "GUID".

How do I retrieve this value to put into a SQL Server? I tried the following:

stmt = SELECT <colName> FROM <tableName>
res = stmt.execute()
value = res.getObject(1) // returns null
value = res.getString(1) // java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Numeric value out of range on column number 1 (<columnName>)
value = res.getInt(1) // java.sql.SQLException: No data found
value = res.getLong(1) // java.sql.SQLException: No data found


What is the right call to get that info out?

Thanks...