Contact GUID via OLEDB?

[Jonathan999]

Is there a way to get the GUID of a Contact by using the OLEDB provider?

[jimdurkin]

Yes you can. Its one of the available fields in the contact view.

SELECT        CONTACTID, CONTACT, COMPANY
FROM            CONTACT

-- Jim Durkin

[Jonathan999]

Thanks! 

My problem was when I ran a

 SELECT * FROM Contact

in Excel there was no ContacId displayed and when I ran

SELECT ContactId FROM Contact 

Excel said there was no such column. 

What I had to do was in Visual Studio run an OleDbReader.GetGuid(i).ToString() to extract the data.

Thanks again!