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