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

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

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

Maybe with ADO

Regards
JY

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

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

the DBF extension is really a "family" of file formats. Which
version/format is your file? (DBF3, DBF4, ??)

--
Regards,
Tom Ogilvy


"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

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