DBF with 503 fields [Archive]

sgkhari

09-23-07, 07:37

Hello All

I have a DBF with 503 fields. Just I got this no of fields when I open it thru dBase V. Even I am able to oven as a Non dbase file and in read only mode. Just I want to know how it is possible to create such huge DBF. I also want to query the DBF with VB or VFP. Anyone please help me in this regard.

Thanks

Hari

Pat Phelan

10-03-07, 12:49

The DBF file was probably created using Clipper or a similar tool. I think you can open DBF files with that many fields using FoxPro.

-PatP

sgkhari

10-04-07, 01:05

Dear Mr. Pat,

I have tried to open using FoxPro and VFP. I am getting an error message as not a valid table. Which version of FoxPro opens that dbf with so many fields.

Thanks

Hari

Pat Phelan

10-04-07, 09:08

I thought that Visual FoxPro 9.0 would open a DBF with that many fields, but I may be wrong.

You may need to find someone that still has the (MS-DOS based) tools that will correctly access that kind of file, and ask them to move the contents (data) to some mutually agreed format such as XML, CSV, or tab-delimited.

-PatP

loquin

10-04-07, 12:47

You may also be able to import it directly into excel, using one of the foxpro/dbase ODBC drivers, and then save it as a csv ...