I'm trying to write a script that will update records in an MDF database (SQL Sever Express). I was looking into using the pyodbc module and update the fields with Python. Is this possible? Has anyone connected and updated a MDF database this way?
This is what I have so far.
Is it worth it to continue with this script? Or am I wasting my time?
Thanks for the help!
Quick question, is this a geodatabase in SQL Server Express? Or is it strictly a database (i.e. no feature classes, or SDE repository)?
If this is a geodatabase, and the tables are registered with the geodatabase, you should use the arcpy.da.UpdateCursor to make the update.