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
