View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default importing data into excel

Possible alternative?

If you intend to ultimately cull/summarize the data, would you consider
importing the file into MS Access? Then you could us MS Query from Excel to
extract only the data you need.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"paulp" wrote:

i need to import data from a .asc file into excel. the problem is that i need
to import just over 80 000 lines & excel only allows the first 65 500 lines
to import. how do i get the remaining 15 000-odd lines onto the next
spreadsheet?