Information générale
Catégorie:
Produits tierce partie
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement