Jan-24-2020, 09:55 PM
This is the error
"pandas.io.sql.DatabaseEror: Execution failed on sql"
What I need to accomplish is loop through the data in a csv file.
take two of the columns and use them in my sql statement, then execute the sql.
Using SQL Server, pyodbc
This requires an new database connection for each row in the file, unless there is a way to do it all with one connection.
then I need to return each result to a new csv file.
Any advice will be greatly appreciated.
"pandas.io.sql.DatabaseEror: Execution failed on sql"
What I need to accomplish is loop through the data in a csv file.
take two of the columns and use them in my sql statement, then execute the sql.
Using SQL Server, pyodbc
This requires an new database connection for each row in the file, unless there is a way to do it all with one connection.
then I need to return each result to a new csv file.
Any advice will be greatly appreciated.