New sheet when rows above 65000

[bhavesh78]

I am using a SQL to fill up an excel worksheet. If the number of lines retrieved is more than 65536 then the remaining lines get truncated. Is there a way to program it to create a new sheet after the end of sheet is reached and continue copying the result in new sheet and so on?

Thanks a lot.

-BS

 

[Von Pookie]

Not sure if this will help but I've used this in the past. I was just importing a txt file, though:

http://support.microsoft.com/?id=120596

 

[bhavesh78]

Not sure if this will help but I've used this in the past. I was just importing a txt file, though:

http://support.microsoft.com/?id=120596

This definately helps. Thanks.

 

[bhavesh78]

The above code works but the new problem I am facing now is- if the text file is CSV file it does not put the data in appropriate columns- instead everthing is copied into column A. Is there a way to modify the above code to incorporate this change.

Thanks all.