Self taught access user that doesn't understand how a 3rd party is doing something. I would appreciate any help in getting an explanation.
I examined the sql that a 3rd party utilizes and I don't understand how they are getting it to work. The 3rd party sends me text files, empty tables in an mdb, and action queries in the mdb. The SQL in the action queries use INSERT INTO statements. When I execute the queries, the empty tables become populated with the text file data.
Code:
INSERT INTO PROP_ENT ( prop_id, prop_val_yr,....) SELECT PROP_ENT_TXT.prop_id, PROP_ENT_TXT.prop_val_yr,...) FROM PROP_ENT_TXT;
My lack of understanding comes from the fact that the SELECT part of the statement references various source fields when in fact the text files don't have source field names. I pop open the text files in a text editor and I don't see any type of delimiters.
I would appreciate if someone could take a minute and explain to me how this is working without field names being assigned in the text files.
Thanks for helping out a novice user.
Tom in Austin, Texas