0

Read data from excel and copy into SQL

I have the data in Excel file and I need to copy the same into SQL server ( we have table schema based on excel columns) Using python copy method I need to perform this activity I tried this task using copy method but I'm getting an error Can anyone please advise

30th Apr 2021, 5:49 PM
govindraj 110590
govindraj 110590 - avatar
2 Answers
0
By using to_sql method I able to perform this activity. But when I try copy () method it's return an error
30th Apr 2021, 5:51 PM
govindraj 110590
govindraj 110590 - avatar
0
.to_sql() is what you want, I dont know why you get errors on copy(). If need be create another instance of the dataframe and give it .to_sql()
30th Apr 2021, 5:59 PM
Steven M
Steven M - avatar