topic Importing a view from SQL server into a File Geodatabase using Python in Python Questions https://community.esri.com/t5/python-questions/importing-a-view-from-sql-server-into-a-file/m-p/392861#M31098 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I've been trying to automate the building of some GIS datasets from the tabular data of a SQL table. My strategy is to import the SQL table into a file geodatabase for processing. I have been messing around with <STRONG>pyodbc</STRONG>&nbsp; but I cannot quite get it.</P><P></P><P>If someone can point me in the right direction I would greatly appreciate it.</P></BODY></HTML> Tue, 07 May 2019 18:43:16 GMT Simonde_Verteuil 2019-05-07T18:43:16Z Importing a view from SQL server into a File Geodatabase using Python https://community.esri.com/t5/python-questions/importing-a-view-from-sql-server-into-a-file/m-p/392861#M31098 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I've been trying to automate the building of some GIS datasets from the tabular data of a SQL table. My strategy is to import the SQL table into a file geodatabase for processing. I have been messing around with <STRONG>pyodbc</STRONG>&nbsp; but I cannot quite get it.</P><P></P><P>If someone can point me in the right direction I would greatly appreciate it.</P></BODY></HTML> Tue, 07 May 2019 18:43:16 GMT https://community.esri.com/t5/python-questions/importing-a-view-from-sql-server-into-a-file/m-p/392861#M31098 Simonde_Verteuil 2019-05-07T18:43:16Z Re: Importing a view from SQL server into a File Geodatabase using Python https://community.esri.com/t5/python-questions/importing-a-view-from-sql-server-into-a-file/m-p/392862#M31099 <HTML><HEAD></HEAD><BODY><P>Hi Simon,</P><P></P><P>You should be able to use the <A href="https://pro.arcgis.com/en/pro-app/tool-reference/conversion/table-to-table.htm">Table to Table </A>tool.&nbsp; This works with straight SQL tables.</P></BODY></HTML> Tue, 07 May 2019 19:34:23 GMT https://community.esri.com/t5/python-questions/importing-a-view-from-sql-server-into-a-file/m-p/392862#M31099 JakeSkinner 2019-05-07T19:34:23Z