Transfer data to FoxPro Table

Dear Friends

I need the code for transfer of data from xl sheet to Foxpro Table.

Syed Haider Ali

Hi:

I've done a bit of work recently taking a spreadsheet to a FoxPro cursor. I found that the quickest way was to save the spreadsheet as a dbf, but when I did that I lost some of the longer fields (above 30 characters I think). I also had trouble if the first row of spreadsheet data had blank cells - had to fill them with zeros.

So what I ended up doing was create a blank cursor in vfp (manually, using create table, and specifying all the columns), then using Append from <workbookname> XL8 Sheet '<sheetname>'.

Some of my problems may have arisen because I was taking the spreadsheet to a cursor rather than a table.

hth
Mike