MrExcel Publishing
Your One Stop for Excel Tips & Solutions

large file size


Posted by Tim Butcher on April 05, 2001 11:31 AM

Can you split a large DB generated file that would
normally exceed the Excel 65,000 line limit? I can run the query for half the data twice but would prefer to split it in Excel. Thanks


Posted by Bob on April 05, 2001 12:57 PM

I have done it, but we have unique vendors. You can allow Microsoft Query bring back all
the records it can, then sort by the 'Unique' Vendor. Find out which one is the last vendor.
Example, it brought back ADC through PEN, then on another sheet Query every vendor >= 'PEN'.

The first Query would look something like this...

Select
T1.Vendor
T1.Item
T1.WHCOST
T1.WHCORE

from Datawhse.dwqrydata.dcitems t1

Order by t1.Vendor

Then the next SQL would be,

Select
T1.Vendor
T1.Item
T1.WHCOST
T1.WHCORE

from Datawhse.dwqrydata.dcitems t1

Where Vendor >='PEN'

Order by t1.Vendor

Posted by Mark W. on April 05, 2001 1:42 PM

See...

http://support.microsoft.com/support/kb/articles/Q120/5/96.asp?LN=EN-US&SD=gn&FR=0&qry=import%20row%20limit&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97