In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server. The DBMS layout is the same for all municipalities.

When I create a linked table from the SQL Server, I can save (or load) a .sql file in the MapInfo dialog.

This .sql-file is portable and I can share it with municipalities with the same setup – but only with MapInfo-municipalities.

Recently I had a post at a conference on this item and I urged my colleagues to use my .sql-files and/or my source code. I was however unable to guide my colleagues from the ArcGis-municipalities.

Can anyone give me some heads up on this matter? Is it possible to do In ArcGis? The .sql file from MapInfo contains the plain SQL query which is sent to the SQL Server:

I.e. :

"JY72000V"."VEJ_NAVN"+ ' '+ "JY72000V"."HUS_NR" As Adresse, 
"JY70100V"."KOMMUNENUMMER" AS Kommunenummer, 
"JY70100V"."EJENDOMSNR" AS Ejendomsnummer, 
Cast("JY72000V"."KOMMUNENUMMER" As varchar(3)) + Cast("JY72000V"."VEJKODE" as varchar(4)) + "JY72000V"."HUS_NR" As ADRESSE_ID
From "ql5020pd"."dbo"."JY70100V", "ql5020pd"."dbo"."JY72000V"
Where "JY70100V"."ADG_ID"="JY72000V"."ADG_ID"

Thanks for any help

Søren Breddam,

Stevns Kommune

1 Answer 1


You should be able to do this using the Query Layer functionality in ArcMap. From File->Add Data->Add Query Layer. This should allow you to add as a layer (or table) a standard SQL query. See example below:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.