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