Embassy Database ODBC

wpe31.jpg (1670 bytes) logo

This Embassy Database includes the names, addresses and phone numbers for the representatives of all 108 countries.

This database lists the name, state, district, and telephone number for all Ambassadors plus US Consulate Offices.

The data file is available in a variety of formats

Contact Managers ACT!, GoldMine, Maximizer, SalesLogix, SalesForce, Sharkware, TeleMagic ACT! Goldmine Maximizer SalesLogix SalesForce SharkWare TeleMagic
Personal Information Managers Outlook, Palm, Maestro, PocketPC Outlook Palm Maestro     HP.gif (15238 bytes)
Enterprise Managers Netledger, Oracle Business Suite, Groupwise, Lotus Notes NetLedger.jpg (1350 bytes) Oracle GroupWise Lotus Notes
Database Managers Access, FoxPro, dBase, FileMaker, Lotus Approach, Paradox, R:Base, Oracle, MS-SQL Access FoxPro dbase.jpg (1184 bytes) wpe1E.jpg (951 bytes) wpeC.jpg (1273 bytes) wpe10.jpg (1283 bytes)  wpe1B.jpg (1499 bytes) wpe28.jpg (1244 bytes) wpe9.jpg (1289 bytes)
Spreadsheets Excel, Lotus, Quattro wpe11.jpg (1183 bytes)  wpe7.jpg (1163 bytes)
Word Processing Mail Merge Word, WordPerfect, WordStar, Wang Word  wpe5.jpg (1159 bytes)  WordStar.jpg (1184 bytes)  wpe20.jpg (905 bytes)
ASCII format Delimited, DIF, TXT wpe5.jpg (1168 bytes) wpe14.jpg (1194 bytes)

Other formats available upon request

We can also help with consulting in the above software systems, for a reasonable fee.  You may be able to laod your Access or Excel file yourself.  But we can help, if you need assistance in uploading the data in to an Oracle SQL format on a back end server.   We also can help you with training in the above programs.

access.jpg (1135 bytes) Microsoft Access Format
Our most popular format

Each file is formatted as a variable number of fixed-length records made up of four fixed-length, tab-separated fields, defined as follows:

DC Address
DC Phone
DC Fax
District Phone
Web Site

Each record ends in an ASCII CR-LF pair. The total record length (including tab separator and CR-LF characters) is exactly 21 bytes.

Sample Records:

We send the file to you in compressed format, using PKZip or WinZip.  If you want to decompress the file sent via email, you will need at least 1MB of free space on your hard disk.

Click for an example of the data in ACT! format

Price Plans

Current data
One download any time


Coming soon: more staff info for $60

Yearly Subscription / Quantity Discount
if ordered once per year for a $60 discount
Four quarterly updates for the price of 3


If you need consulting help importing the data: click here

If you need training in using software, click here

Order Form

Please sign and fax the Agreement
ICHCKLGO.gif (700 bytes)

Write Your Ambassador!

Why Diplomats Can Be Your Best Customers

Diplomats are the most affluent and free spending group in New York City andWashington, D.C. They also constitute one of the largest and most important industries. This is no surprise in that the members of the diplomatic community assigned to posts in New York and Washington are the most senior, influential and well compensated officials in each country's diplomatic delegation.

High Disposable Income
 Frequent Travel
Frequent Dining, & Entertaining
Trend Setters in Their Respective Countries


In ACT! go to Edit, Preferences
to add the First name prefixes for H.E., His Excellency, and Her Excellency
to clarify to ACT! that these are not first names.



Trademark acknowledgements