Import selected columns from Excel to SQL

[Tim]

I would like to import selected columns from Excel to a SQL table. I was trying
to use the DTSWIZ utility, but it only sets up the selecting of the columns
from the Excel worksheet. I would like to know how to finish the script to
complete the task.

Thanks,

Tim

[David Satz]

another way to do this is to build INSERT and update statements w/in Excel
using the CONCATENATE() toreference the cells

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
"Tim" <Tim.Shirey@attws.com> wrote in message
news:3db69b65$1@tnews.web.devx.com...
>
> I would like to import selected columns from Excel to a SQL table. I was
trying
> to use the DTSWIZ utility, but it only sets up the selecting of the
columns
> from the Excel worksheet. I would like to know how to finish the script to
> complete the task.
>
> Thanks,
>
> Tim