Hi There
Hopefully someone will be able to help me.
I am importing a set of tables to a database every month, I then need to extract data from these tables but each month the make up of the columns could be slightly different.
The constants are as follows:
The first 5 columns are always the same and the final column also, I need a way to extract data from the columns in between these two constants. Sometimes there may be one column in between others there may be 20.
Is this possible ?
Thanks in Advance
Rich
Hopefully someone will be able to help me.
I am importing a set of tables to a database every month, I then need to extract data from these tables but each month the make up of the columns could be slightly different.
The constants are as follows:
The first 5 columns are always the same and the final column also, I need a way to extract data from the columns in between these two constants. Sometimes there may be one column in between others there may be 20.
Is this possible ?
Thanks in Advance
Rich