Hi guys,
I got a question. is it posible that using an ODBC with excel to have number of columns variable. this means today my excel have 5 columns, tomorrow i add a new one. how can i make that the new column that i create, automatically appear into my odbc query and columns define.
Thanks
Variable columns in ODBC
Moderators: chulett, rschirm, roy
Variable columns in ODBC
Juan Escalante
IT Consultant
IT Consultant
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without re-importing the table definition it is not possible. And even then the new metadata can not be propagated automatically in server jobs.
Short answer: it's not possible.
Short answer: it's not possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.