>>I'm not sure, but As far as I know they don't own us anything and give the files only by their good will. So, we can not demand a same format all the times. Now I'm facing a problem, what I need to re-define the table structure. Well, I'll do it today, but may there is at least simple method to compare file structure (in the first record, though it could be changed too) with the table's current structure. In other words, is it possible to automate this process?
>
>
>Only if you could get the first record in the text file (since it contains the structure) and compare it with other known examples. You could probably use a table that not only has all known examples but the file structure information as well.
>
Yes, this is what I'm thinking to implement. I would just implement this simple check and get a warning... However, the table structure is different from the names I have in this string, which makes it a little bit more complicated. For instance, they named fields First_Name, Last_Name, Street_Address, and I name them FirstName, LastName, Address... Anyway, I think I can go from this idea... If the structures would not correspond, I'll give a messages and invoke modify structure dialog...
If it's not broken, fix it until it is.
My Blog