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)
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