sir se my code that run perfectly without any error and show the Pandas data but did not insert pandas data to MS Access database table please see my code and give me right code for insertion of data to MS Access table
<code>import pyodbc
import pandas
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:erpmfapython.accdb;')
cursor = conn.cursor()
df = pandas.read_sql("SELECT * FROM mfa1", conn)
print(df)
df['SNAME'] = df['SNAME'].astype('str')
df['FNAME'] = df['FNAME'].astype('str')
df['ADDRESS'] = df['ADDRESS'].astype('str')
df['FEE'] = df['FEE'].astype('int')
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], format='%d%b%Y:%H:%M:%S.%f') # is give me error not conver object to date
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], infer_datetime_format=True) # is give me error not conver object to date
test_data = df[["SNAME","FNAME","ADDRESS" ]]
print(test_data)
cursor.executemany( f"INSERT INTO [mfa1] (SNAME,FNAME,ADDRESS) VALUES (?, ?, ?)", test_data.itertuples(index=False))
cursor.commit
conn.commit
# test_data.to_sql('mfa1', engine, index=False, if_exists='append') #this line give error
</code>
<code>import pyodbc
import pandas
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:erpmfapython.accdb;')
cursor = conn.cursor()
df = pandas.read_sql("SELECT * FROM mfa1", conn)
print(df)
df['SNAME'] = df['SNAME'].astype('str')
df['FNAME'] = df['FNAME'].astype('str')
df['ADDRESS'] = df['ADDRESS'].astype('str')
df['FEE'] = df['FEE'].astype('int')
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], format='%d%b%Y:%H:%M:%S.%f') # is give me error not conver object to date
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], infer_datetime_format=True) # is give me error not conver object to date
test_data = df[["SNAME","FNAME","ADDRESS" ]]
print(test_data)
cursor.executemany( f"INSERT INTO [mfa1] (SNAME,FNAME,ADDRESS) VALUES (?, ?, ?)", test_data.itertuples(index=False))
cursor.commit
conn.commit
# test_data.to_sql('mfa1', engine, index=False, if_exists='append') #this line give error
</code>
import pyodbc
import pandas
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:erpmfapython.accdb;')
cursor = conn.cursor()
df = pandas.read_sql("SELECT * FROM mfa1", conn)
print(df)
df['SNAME'] = df['SNAME'].astype('str')
df['FNAME'] = df['FNAME'].astype('str')
df['ADDRESS'] = df['ADDRESS'].astype('str')
df['FEE'] = df['FEE'].astype('int')
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], format='%d%b%Y:%H:%M:%S.%f') # is give me error not conver object to date
#df['FEEDATE'] = df.to_datetime(df['FEEDATE'], infer_datetime_format=True) # is give me error not conver object to date
test_data = df[["SNAME","FNAME","ADDRESS" ]]
print(test_data)
cursor.executemany( f"INSERT INTO [mfa1] (SNAME,FNAME,ADDRESS) VALUES (?, ?, ?)", test_data.itertuples(index=False))
cursor.commit
conn.commit
# test_data.to_sql('mfa1', engine, index=False, if_exists='append') #this line give error
test_data.to_sql(‘mfa1′, engine, index=False, if_exists=’append’) #this line give error
2