I have to read an Excel-File into DTS to append data to a SQL database.
Within the Excel file I have my data in columns and not in Rows. Is
there a possibility to read this directly through JET OLEDB?

If this is a one off, then copy the data in the excel file and transpose
it so that it's readable by DTS.
DTS is reading row by row, there isn't a mechanism that I can think of
that would allow you to put columns into rows (easily if at all).
Transposing the data would be the easiest way to go.

Simon Worth

mhuhn.de (AT) gmail (DOT) com wrote:

Thanks for your answer. Unfortunately it is a frequently automatically
updated file so I have to think about writing sth. like an
OLEDB-Wrapper to do the Transposition.