title: Pandas to_sql right truncation error
body: <p>I'm trying to use Pandas to_sql to insert data from .csv files into a mssql db. No matter how I seem do it I run into this error:</p>
  
  <pre><code>pyodbc.DataError: ('String data, right truncation: length 8 buffer 4294967294', '22001')
  </code></pre>
  
  <p>The code I'm running looks like this:</p>
  
  <pre><code>import pandas as pd
  from sqlalchemy import create_engine
  
  df = pd.read_csv('foo.csv')
  engine = create_engine("mssql+pyodbc://:@Test")
  with engine.connect() as conn, conn.begin():
      df.to_sql(name='test', con=conn, schema='foo', if_exists='append', index=False)
  </code></pre>
  
  <p>Any help would be appreciated!</p>
  
  <p>P.S I'm still fairly new to python and mssql.</p>