Forum Discussion
I understand the idea, the only problem is that this object does not have the same interface as the DB Table.
Is there a property or a casting possible?
I could not find it in the TC documentation.
No, there is not a casting available. My suggestion is that you move away from using the DBTable variable type and move to the DDT object.
Again, that is depending a bit on what you are doing with the data. The DDT object creates, essentially, a data record set that can be iterated through row by row, usually in a while loop.
If, however, you need something more direct, you can use the Excel.Application object to access the excel workbook. The code is different but, again, you may need to rework how you are consumming the data object.
Basically... there is no way to do what you are wanting to do using the DB Table variable type. So, you need to convert to use a different method of connecting to your Excel database so you can have a more variable way of opening the files.
Related Content
- 3 years agoOfer-Yaniv
- 8 years agovikram_u_k
Recent Discussions
- 6 hours agoSvetaG