>As I looked over my code and went step by step thru it to locate my problem, I managed to find a HUGE portion of it. I use the automation to format the cell range correctly in the Excel file. However, when I copy it to a VF table, the procedure overwrites the table structure and replaces it with a new one. Thus I used COPY STRUCTURE and then did an ALTER TABLE. However, then I got a sharing violation to it when I tried to bring over the data into the table. It seems like when Excel is bringing data into Foxpro, it does not convert dates that well. It turns the date field into a numeric. Thus a typical date will turn into something like 37111. I have tried every method to convert it, but it will not come over. Does anyone have any ideas on how to maintain the date field in Excel to remain a date field when bringing it to Foxpro.
>
>Or a method to convert the numeric value of a date into a date form.

Take a look at XL8 import Message #655336. It shows how to convert serialized number into the date.