Donald,
Isn't APPEND FROM ... DELIMITED BY .... what you want ?
Regardless of what you use, however, you WILL need to have some idea
of how many fields your table needs to have, their type, and their
capacity (length). This you will get either from the people sending
you the file, or from looking at the file with an editor and working
out from that what the layout of your file should be.
Michel Creppy.
===============================================================
>I know that I've just got a brain cramp, but maybe one of you could help. I want to get a comma seperated file in a table. I don't know the lengths of the fields coming in so I can't predefine a table to put them into. I know that the Import wizard in VFP6 does this, but I'll be darned if I can figure out how.
>
>So, is there an answer out there, or at the very least can I look at the code for the import wizard to figure out how to do it?
>
>Thank you in advance.
>
>DJ Hunt :o)
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