Importing a view from SQL server into a File Geodatabase using Python

280
1
Jump to solution
05-07-2019 11:43 AM
Simonde_Verteuil
New Contributor

Hi all,

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 pyodbc  but I cannot quite get it.

If someone can point me in the right direction I would greatly appreciate it.

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

Hi Simon,

You should be able to use the Table to Table tool.  This works with straight SQL tables.

View solution in original post

1 Reply
JakeSkinner
Esri Esteemed Contributor

Hi Simon,

You should be able to use the Table to Table tool.  This works with straight SQL tables.