Breaking News: Grepper is joining You.com. Read the official announcement!

upload file to SQL server pyodbc python

S3NS4 answered on June 21, 2022 Popularity 1/10 Helpfulness 1/10

answer upload file to SQL server pyodbc python

upload file to SQL server pyodbc python

Comment

# Get connection
connection = pyodbc.connect(...)
filename = 'MyFile.pdf'
insert = 'insert into FileTable (name, document) values (?,?)'

# open file as binary and read into a variable
with open(filename, 'rb') as f:
    bindata = f.read()

# build query
binparams = ('MyFile.pdf', pyodbc.Binary(bindata))

# insert binary
connection.cursor().execute(insert, binparams)
connection.commit()
connection.close()

Popularity 1/10 Helpfulness 1/10 Language python

Source: www.hackersfriend.com

Tags: file pyodbc python sql-server upload

Link to this answer
Share Copy Link