I would say, excel sheet and foxpro table differ from each other. Therefore some standard should be followed to get things done properly.
As a rule, Excel users do not put attention on the formatting. The very same column can contain data with different format. So, somehow program should audit the source file or the result set.
In Excel user can remove the contents of the records somewhere, but rows are still in the sheet. He/she meant to delete records but did not. Again, the program should audit records or use append for not empty() clause.

And so on.

Hope this help.

>>>>>>>>>>>>>your message below
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.