View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Importing text file

You can open the file in Notepad and then split up the file by cutting rows
from the source file and pasting them into a target file. I would create a
backup of the original data file and then proceed with splitting the data
over multiple files.
--
Kevin Backmann


"Jeff" wrote:

Hi,

I have a text file that is over the number of rows = 65K. So is there any
way to import the first 65K rows and then the next rows?

I tried importing the text file into acess but it did not work.

Thanks for your help.