![]() ![]() ![]() When I run the python code, sql server has 225 records. Every day 10 to 20 new records are adding in the excel.Įxample : Today's my excel file record is 100 and tomorrow it become 125 records (25 new records). My excel file is updating every day and when I run the above every day, the SQL server generate duplicates. I can able to push the data from excel into SQL server. #I have already created table in SQL Server My code as follow,Ĭnxn = nnect('DRIVER= SERVER='+server+' DATABASE='+database+' UID='+username+' PWD='+ password) I am taking the excel file and uploading into SQL server using Python. I am having excel file which updates every day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |