>I got it dude!
>
>1. You have to set century on.
>
>2. Append the date data into a character field.
>
>3. Append that table into another table with the same field as date instead of character.
The above doesn't work. The data comes into the date field the same from the table as from the text file. Which is strange.
> Or, modify the structure of the first table and make the field date instead of character.
This works... hadn't thought of that. My idea was to import with the date field as C(10) then add a date field and replace datefiel with ctod(cfield).
Thanks for the help... was hopping there would be an easier way.
BOb
Précédent
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