BTW, forgot to mention, that this file is huge. It could not be opened by WordPad. I'm trying with Excel now, but it seems like it hangs up... VFP opens file with no problems.
>Hi everybody,
>
>We received text file (txt extension) from external source. The fields didn't have quotes around them. I think, this file was accompanied with a layout. Now we received another file with different structure and now char fields have quotes around them.
>The first record in both files contains field names.
>
>My question is: how can I automate the process of uploading this file into the table. I have table with a structure, but it doesn't work for the new structure, so I have to re-create it guessing by field names their format. Is it possible to another way? Say, through Excell automation? The table will be created on the fly...
>
>Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog