Need Help Exporting More Thank 65,536 Rows Of Data!

[DCBBB]

I am running a report which return more than 65,536 rows of data, which seems to be the limit default in the datamart. Is there any way for me to export all rows of data to a .txt, .xls, .dbf, etc format? When I try, it seems that all rows beyond 65, 536 are lost. TIA.
D

 

[andresvc]

Try with your DB

 

[DCBBB]

Hi,
Do you mean export it directly into an Access database? When I try that, it still cuts off records beyond 65k. I am begining to think it can't be done unless that Datamart limit is reset - which my administrator indicates will require an upgrade. May have to cut this report into chunks - big pain but may be the only route for me. Thanks.
D

 

[andresvc]

Hi D.

Are you heard about DTS of SQL Server??????

If you use DTS you can export or import a lot of information of different platforms very easy, and is free when you buy a license of SQL Server, try with this tool and you can minimize your problems...... I use it.

If you want more information give me your e-mail address.

Regards.

 

[nlim]

excel is limited by row limit around 65K, so it won't help you much...

 

[DCBBB]

Yes, there is that annoying Excel limit. But actually, my primary goal is to get the data into Access, so .txt, .csv, and .dbf would be fine. The solution our IT department settled on is to open up the datamart so I can write tables of any size. Thanks for all the feedback.
D