I am creating a connection to a SQL data source and it is returning too much information for sheet1. How can i have it populate sheet2?

Your SQL returns more than 1048576 rows? If so, see: https://support.microsoft.com/en-us/kb/120596. You should be able to adapt the code there. Remember to replace the code references to 65536 with 1048576. However, that also implies your SQL data are being output to a text file from which you can import it into Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Also, if it is of use, the Powerpivot free add-in from MS allows much more than 1 Mio rows

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Macropod
Thanks for your reply. Yes it returns more than1048576 rows. I had seen this but wasn't sure it would work being i am importing directly into excel.

Pecoflyer
Thanks for the advice. I will check with the IT department to see if they can download this for me.