Enter ‘Rotterdam’ in the first search field and select City from the pull-down menu behind it.
Enter ‘1921’ and ‘1940’ in the fields marked active between.
Click on add all to my data.
In the saved data window (if the window is not visible, click on My Data at the top of the page), click on download contents. Save the results file in a folder you can access easily.
In order to answer this question, you must have the file HowToDoInAccess.xslt on your computer. If you have not installed this file yet, then follow use the method indicated in our FAQ Where do I find the transformation file and what is it for? and then continue to Step 3. If you have installed this file already, then follow the procedure outlined below.
Launch MS Access.
Select File > New from the upper left corner.
On the right-hand side of the screen, create a Blank database.
Store the database in a folder that is easily accessible.
Click on File > GetExternal Data > Import.
Select XML from the pull-down menu Files of type and then choose the file you had saved before (the saved data set) with the found data.
Click on Import.
Click on Options > Transform.
Select HowToDoInAccess, click OK to confirm, and then OK once more to import the data.