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

Question

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.

jskinner · Accepted Answer

Hi Simon,

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