AN EU consolidated electronic list concerning persons
and entities subject to EU financial sanctions
Background information Day-to-day use DBMS use
Day-to-day use: work with Excel

You have to work with EXCEL 2002 and above. Excel 2002 and above understands XML as a "native". language.

Steps to follow:

    1. Download the desired XML file (from http or ftp sites) and 'Save it to disk' (the procedure for saving XML files is not different from the procedure for saving documents in other formats)

    2. Open Excel

    3. Go in "Data - Import External Data - Browse to XML file location"

    4. Click "OK" to the Dialog Box "Import Data"

    5. In order to sort the data by name, ID, last name ... you have to create filters (go in Data - Filters - Advanced Filters)

    For supplementary information on Excel 2003: http://server1.msn.co.in/computing/officexp/xml_excel.html

Remarks: you can always use VB to write advanced search tools
[print] [close]