with pyodbc.connect("Driver={SQL Server Native Client 11.0};" "Server=server_name;" "Database=table_name;" "Trusted_connection=yes;") as db: cur = db.cursor() sql = """SELECT TOP 5 * FROM Table""" cur.execute(sql) with open("C:/Users/PYTHONDUDE/Documents/PYTHON_SCRIPTS/.test.txt", "w", newline='') as f: for row in cur: print(row[0], file=f)NB - not tested, but should work
[PYTHON EXPORT SQL TO .txt file]
Messages In This Thread |
[PYTHON EXPORT SQL TO .txt file] - by PYTHONDUDE - Feb-21-2018, 02:56 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by buran - Feb-21-2018, 03:12 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by PYTHONDUDE - Feb-21-2018, 03:14 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by buran - Feb-21-2018, 04:30 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by PYTHONDUDE - Feb-21-2018, 04:49 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by nilamo - Feb-21-2018, 04:56 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by nilamo - Feb-21-2018, 08:54 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by buran - Feb-21-2018, 05:10 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by PYTHONDUDE - Feb-21-2018, 06:45 PM
RE: [PYTHON EXPORT SQL TO .txt file] - by buran - Feb-21-2018, 08:26 PM
|
Users browsing this thread: 2 Guest(s)