Welcome!
By registering with us, you'll be able to discuss, share and private message with other members of our community.
Recent content by ahmedbarbary
-
Python How to modify python script to append data on file using sql server 2019?
this is python pandas @script = @PythonScript can you help me please- ahmedbarbary
- Post #3
- Forum: Python
-
Python How to modify python script to append data on file using sql server 2019?
I need to append data to excel file already exist from table students on SQL Server . Excel file already Created on D:\ExportExcel\dbo.students.xlsx with student IDs 1 and 2. Table Insert Commands: INSERT [dbo].[students] ([StudentId], [Name]) VALUES (3, N'Sayed') INSERT [dbo].[students]...- ahmedbarbary
- Thread
- Replies: 2
- Forum: Python
-
Python How to keep columns header on excel without change after export data to excel file?
I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist, and keep header without change after export. header of excel file StudentExport.xlsx before export data to it as below StudentId,StudentName after...- ahmedbarbary
- Thread
- python 3 sql sql server
- Replies: 0
- Forum: Python