I created a ODBC connection, select my table and field and dump back to Excel. All looks great.
I then go to "edit query". During the edit process when using MS Query the table sql code changes "without" me doing anything.
Ex.
1st connection command text code:
SELECT PMLD.CODE
FROM BUS12.LEB.PMLD PMLD
Try to edit the connection the command text changes when MS Query opens
SELECT PMLD.CODE
FROM BUS12.ASD.PMLD PMLD
What would cause this change to occur?
TY
I then go to "edit query". During the edit process when using MS Query the table sql code changes "without" me doing anything.
Ex.
1st connection command text code:
SELECT PMLD.CODE
FROM BUS12.LEB.PMLD PMLD
Try to edit the connection the command text changes when MS Query opens
SELECT PMLD.CODE
FROM BUS12.ASD.PMLD PMLD
What would cause this change to occur?
TY