Re: Newbie: Update From Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The data is still in excel, what is BOL?

"Allan Mitchell" wrote:

> The statement that you there will not work.
>
> Is the data still in Excel or have you imported it?
>
> You would need to use an ExecuteSQL task to do it the way you detail and
> you will need to use either a Linked Server or OPENDATASOURCE to query
> the Excel spread***. Examples of both are in BOL.
>
> You can alternatively use a DataPump to transfer the data easily enough
> if the format is OK.
>
> Allan
>
> "Cavan Vannice" <Cavan Vannice@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:Cavan Vannice@xxxxxxxxxxxxxxxxxxxxxxxxx:
>
> > I am a newbie at SQL Server, but I do have a little experience from
> > Coldfusion. Here's my Question.
> >
> > We have a database for our business. We sell products. and we get price
> > lists in excel format all the time. I am working with DTS and I would like to
> > set it up, so that I can format the spread***, properly and execute the
> > package. easy as 1,2,3 right?
> >
> > Well I have tried many things from doing it in SQL DTS to Access, and
> > everything is a no go. I have limited SQL knowledge but here is of the things
> > I have tried and it seems to me it should work.
> >
> > INSERT
> > INTO Product (ListPrice)
> > SELECT ListPrice
> > FROM
> > [Product$]
> > WHERE (ProductID = Product $ .ProductID)
>
>
.

Quantcast