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