Python Forum
Output SQL to csv or xls file?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Output SQL to csv or xls file?
#1
Hi,
Have a bit of code that runs a sql query - can't seem to get it to output to a .csv or an .xlsx file. Any help is appreciated

The window has several buttons, each of which should generate a report. The button label in this example is "Count of All Codes" - just trying to change the last line so that it writes to a file like "C:/mytestfile.csv"

if event =="Count of All Codes":
    connstring = 'DRIVER={SQL Server};SERVER=XXX;DATABASE=XXX;UID=XXX;PWD=XXX'
    SQLStr = "SELECT subsource_type_desc,  COUNT(*) AS 'num' FROM [TSCACS] GROUP BY subsource_type_desc order by num desc"
    conn = pyodbc.connect(connstring)
    cursor = conn.cursor()
    cursor.execute(SQLStr)
    for row in cursor:
        print(row)
Thanks again for any help.
Reply
#2
Check out the csv module. It makes it very easy to write csv files.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply
#3
Thank you, I have read through as much of the csv documentation as I can find, but I cannot get it to work. Literally every time I run it, I fix some syntax error, then get another one. It seems that the code I'm finding and trying is either outdated, wrong, or I'm just incapable of figuring out all of the syntax and structures required.

If you know of anything reasonably stable that you could point me to, I'd happily give it another shot.

Otherwise, if anybody else could give me a hand with the code I have above, I'd be most grateful.
Reply
#4
Why don't you post some of the csv code you tried, and we'll help you fix it?
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply
#5
Thank you for getting back to me. This is probably my 20-25th try just to get sql results into a .csv, and unfortunately, I don't keep code after continuous failures (at some point I have to go back to the starting line and I delete everything I had done prior). So I'm sorry to say, I have no evidence of what I've worked on up to this point, only the base code that gets me to what I thought was like 95% of the way there.

But I understand that your goal is to help people learn, not do for them, so you can feel free to move on to other users who need help and delete this thread. The next time I attempt to do something in Python I'll keep the text file copies of my dry runs so I can be more aptly prepared for forum help requests.

Have a great day and thanks again for your time.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,046 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Output CSV file with filepath and file contents glittergirl 1 1,705 Aug-03-2020, 01:50 AM
Last Post: glittergirl
  csv file output rturus 7 3,152 Jan-30-2020, 02:09 PM
Last Post: buran
  File name as part of output file name Jeeping_Coder 1 2,076 Jan-10-2020, 03:43 PM
Last Post: Clunk_Head
  How to extract a matrix from .xml.gz file to a excel file or any other output? enyrb 0 2,029 Oct-21-2019, 01:01 PM
Last Post: enyrb
  python file output to log file Rsh 4 3,641 Aug-13-2019, 09:00 PM
Last Post: DeaD_EyE

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020