Hi,
I wish to import data from XLS into SQL Server using DTS. However, i want
only a particular cell mapped to some column in a table in database. For
example, C(9,9) of the XLS should get mapped to Column X in Table Y.
Is it possible to do this in DTS? Or do i need to create a staging XLS or
staging table?

Thanks,

Technically most things are possible.

DTS Sees data so when DTS in the DataPump task opens up an XL
Spreadsheet it can see named ranges and workbooks.

As for taking a specific cell? Hmmm, You could do it but it would have
to be a named range and that makes it a single table of 1 cell. It may
be easier to use the Excel object model to read the value of that cell
into a global variable and use that in a Query to insert into a table



"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote