Hi Stefi,

Is this a one-time operation or will you do it on a regular basis? You could
try importing/linking the table in Access and then using queries to separate
the table into more manageable chunks.

--
Cindy Winegarden



VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




"Stefi" wrote in message
...
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