Community
Showing results for 
Search instead for 
Do you mean 
Reply

Contact GUID via OLEDB?

New Member
Posts: 8
Country: USA

Contact GUID via OLEDB?

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

Bronze Super Contributor
Posts: 1,231
Country: USA

Re: Contact GUID via OLEDB?

 

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

 

SELECT        CONTACTID, CONTACT, COMPANY
FROM            CONTACT

 

-- Jim Durkin

New Member
Posts: 8
Country: USA

Re: Contact GUID via OLEDB?

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!