Read data from excel and copy into SQL

Question

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

Answer 1

By using to_sql method I able to perform this activity. But when I try copy () method it's return an error

Answer 2

.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()