found this posting at the access discussion group.

http://www.microsoft.com/office/comm...xp=&sloc=en-us

"Stefi" wrote:

Thanks Mike, I had a look at the site, but it deals only with TXT or CSV
files. My goal is to import a DBF file purely via VBA tools, without the need
of previously converting it in a separate session.

Regards,
Stefi


€žMike H€� ezt Ã*rta:

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