Thread: large DBF file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default large DBF file

Have a look he-

http://www.cpearson.com/excel/ImportBigFiles.htm

Mike

"Stefi" wrote:

Hi All,

I have a DBF file with more than 65535 records. I'd like to read it with
XL2003. I know that XL2003 reads only the first 65535 records when opening
the file. My question is that is there any way via VBA to access records over
65535, e.g. into another sheet?

Thanks,
Stefi