Hi All
Iam using SQL 2000 dts to upload multiple MS Excel 2003 workbooks into a sql db/table. Each workbook has multiple worksheets with formulated data. I have created a sheet at the end of each workbook to vlookup each value from the other sheets per workbook and all I want to do is upload the last sheet 'SQL Upload' into the sql db/table which has all the correct column mapping. But when in the dts I select the transformation bar and it defaults to source I cannot pickup any sheet from a workbook. It just has a blank column, I cant drop down or even type anything in this coulmn.
Anyone any ideas?
Many Thanks for your help
Iam using SQL 2000 dts to upload multiple MS Excel 2003 workbooks into a sql db/table. Each workbook has multiple worksheets with formulated data. I have created a sheet at the end of each workbook to vlookup each value from the other sheets per workbook and all I want to do is upload the last sheet 'SQL Upload' into the sql db/table which has all the correct column mapping. But when in the dts I select the transformation bar and it defaults to source I cannot pickup any sheet from a workbook. It just has a blank column, I cant drop down or even type anything in this coulmn.
Anyone any ideas?
Many Thanks for your help