Hi Russell,

I'm not skilled at this, but I have seen the case where clicking on a field disappears it, and it was caused by there being multiple fields generated with the same field name.
For example, one I had had headings like "Ref_Doctor_Address", "Ref_Doctor_Phone" etc and they all ended up as "Ref_Doctor_" as field names.

good luck


>I have a situation where I need to import data from an Excel spreadsheet. Normally, this is fairly straightforward, however this is a spreadsheet that's being used like a database to generate quotes. There is a "header" section consisting of 16 rows that has information such as customer name, date, a logo, a button for customer lookup, etc. The line items on the quote are on lines 17 through whatever. Using a "standard" import (choosing Import off the File menu and letting VFP do it's thing), the data does get imported, however some fields have a nonprintable character in front of them and the last character of text is missing. Also, when you put the cursor in that field, the contents disappear. Then there's an issue with a date field. It comes in as a number. I've also tried importing by creating a table (making the 28 fields C(80)) and issuing an APPEND FROM ExcelFileName TYPE XL8. This didn't help. I'm thinking of two possible solutions: 1) I try multiple imports to
>tables with different structures to extract out what I need or 2) I use automation to open the file and pull the data out of the spreadsheet in a more "manual" fashion. Any suggestions would be appreciated.
>
>Russell Campbell