General information
Category:
Third party products
>Lea
>
>if you are certain that only 2 fields are not displayed properly, then why dont u write a small procedure to modify the table after the data is imported.
I had thought of that; however, when the data is imported from XLS to DBF, the date fields are converted to whole numbers and then to character. So the date: 01/01/2002 comes out to be 39781. What the heck is that? I tried to reconvert the information by CTOD(), but the system could not reverse the process. I wanted to even see if the process was faulty. I used the import wizard and did it that way. then I copied the structure as it was to a new table/cursor. Then i used the append from and not all the data came over. Blows my mind because the table was all character and it should have done the same procedure as the import wizard. This is all done in VFP 7.0
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only