large DBF file

[Guest]

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

 

[Guest]

Have a look here:-

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

Mike

 

[Guest]

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:

 

[Jean-Yves]

Maybe with ADO

Regards
JY

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:

 

[Guest]

found this posting at the access discussion group.

http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us

 

[Guest]

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

 

[Cindy Winegarden]

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
(e-mail address removed)


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