Hi Fred, The past few months have been kind of crazy, personal life and all. Project was put on the back burner for a few (Thank God!), but now I must press on. In regard to your question I am using SQL 2005. I was told that after the extract I would possibly need to convert the query information into a .csv file before attempting to convert it Excel. Let me knwo what you think! Thx sk8te320

Hey divyamistry, Haven't sunk my teeth into it yet, hope to get to it in the next couple of days but will keep you in the looop. sk8te320!

Dear divyamistry, I appreciate the help. It's not to often you receive advise that so in depth. Sorry I didn't get back to you earlier, but we've been having some system problems at work and things have been kind of crazy. I look into your suggestions, they seem like what I've been looking for, who knows, maybe one day I'll be able to return the favor. Thx again, sk8te320!

Nice try, but that's the first thing I did. Like going down the rabbit's hole, one thing leads to another, but all the while you find nothing with a solid answer. I stated that I was new to SQL and Perl, not the use of a computer and the internet, but thanks for the help, oh that's right, you didn't really answer my question, my bad... :-\

I'm new to both Perl and SQL and have been given a project to attempt writing a Perl script that will execute an SQL query. Then extract the information generated by the query and import it to a Microsoft Office Excel spreadsheet. Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated. sk8te320 Confused

I'm new to both Perl and SQL and have been given a project to attempt writing a Perl script that will execute an SQL query. Then extract the information generated by the query and import it to a Microsoft Office Excel spreadsheet. Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated. sk8te320 :confused:

I was wondering if someone knows how to use a DBI to exec a sql script and copy the data collect to an Excel Spreadsheet?