S.G.K.Hari


Hi all,

I have a DBF with 255 fields. When i give the use command in VFP I am getting an error message as' Not a Table' The same can be opened in Excel. Help me how to open the same.

Hari



Re: Unable to open a table with 255 fields in VFP

Markish


Hi Hari,

It's a VFP limitation. Either you have to go for physical or logical partitioning of the table. For further limitatoins you can refer http://fox.wikis.com/wc.dll Wiki~VisualFoxProLimits~VFP.

Best regards,

Markish







Re: Unable to open a table with 255 fields in VFP

dni

You may need to split the table in two tables with number of fields under 255.







Re: Unable to open a table with 255 fields in VFP

Vasim

Open the file with Excel then Save As "dBase 4" format into another file, try opening the newly saved file with VFP.

Also check the first row in Excel for any spaces in the filed names.

Note: Make sure you use Courier Font, Auto Fit all you columns, and highlight all cells with data before saving form Excel to dBase format.





Re: Unable to open a table with 255 fields in VFP

MaxRalph

Hi I was looking at your answer giving the option to split the Table I'm using v Fox pro 6 and I do have over 255 fileds but could you tell me how to split the Table and thanks in advance