James,

One thing that has helped me a lot with the data type issues is to save the Excel file in .CSV format, set up a CURSOR in VFP and APPEND FROM ... TYPE CSV.

This depends on knowing the format ahead of time though.


>Does anyone have answers on how to successfully import from excel without any issues. Here is my problem. I have an excel file and when i issue an import from c:\myfile.xls xl8 the data types in my cursor end up getting all distorted dates turn to numbers numbers to character and the sinereo is never the same so i have been unable to code around this. I have tried reformatting the collumns through the use of a com object and still nothing. I also tried placing column headers at the top of the columns in excel and importing the file then so that everything would be character the problem with this is when you issue the import from it changes the field lengths and you end up loosing the last few characters off certain fields and even this problem is not consistent enough that you can code around it. I have tried append from and so on and nothing works consistently. Any ideas??? One of the other issues is that if a user enter 30 lines of data in excel and erase 5 of them by just clearing the cells when you do an import it still will see these 20 lines of data cept the erase ones will be empty and this causes me many problems as well. HELP. I would hate to think that these 2 products just cannot work hand and hand.