How to free a dbf table if dbc file is missing

[Sunil]

Hi All,

Hope you guys can help me out. I have export of dbf files without dbc file
included. I would be getting frequent export of these files. I am
developing a vb.net console application to read data from these files.
My application is failing when I try to read count of records in those dbf
files and the error is "Cannot open
file xxx.dbc". (since the .dbc file is missing) I am using the below
connection string
"provider=VFPOLEDB.1; SourceType=dbf; data source=c:\temp\;"

Is there a way to read the files without the database file (dbc) or way to
free the tables programmatically without double clicking the dbf file to
free the table.

Thanks in advance.

Sunil

[Cindy Winegarden]

Hi Sunil,

Please don't multi-post (posting separate times to several newsgroups).
People spend time preparing answers when the question has already been
answered in another group. Most of us who read here read all the groups
anyways.

Who is sending you the data? Why don't they include the DBC/DCT/DCX files?
If you are getting a frequent export then the best thing to do is have the
person on the other end do things the right way.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

Post by Sunil
Hi All,
Hope you guys can help me out. I have export of dbf files without dbc file
included. I would be getting frequent export of these files. I am
developing a vb.net console application to read data from these files.
My application is failing when I try to read count of records in those dbf
files and the error is "Cannot open
file xxx.dbc". (since the .dbc file is missing) I am using the below
connection string
"provider=VFPOLEDB.1; SourceType=dbf; data source=c:\temp\;"
Is there a way to read the files without the database file (dbc) or way to
free the tables programmatically without double clicking the dbf file to
free the table.
Thanks in advance.
Sunil