Updating price list

I've been trying to pull data out of an Excel file and I can get it into
SQL but I have to first pull it into Access.

What I am trying to figure out is how to eliminate that step and just
import from a .txt file from excel. I usually end up running into snags
in the data that don't allow me to import it.

Is there a good trick to doing this?

OK,

As usual, it was probably simpler than I thought it would be.

UPDATE TableTwo
SET TableTwo.Price = TableOne.Price
FROM TableTwo INNER JOIN TableOne ON TableTwo.TwoID = TableOne.OneID
WHERE TableTwo.TwoID = TableOne.OneID

Sorry, I understand

SQL Server 2000

All I need is a basic SQL query that I can plug into MS SQL Query
analyzer so I'm not sure what server format would do.

For that you need to tell us what Server language you are using.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Lee" <lee_nospam_@artjunky.com> wrote in message
news:eneh12$963$1@forums.macromedia.com...
> Ok,
>
> Just to make it a simpler reply, what I really need is to know what the
> SQL would be to update one table/price using a 2nd table's price column
> where the IDs are the same in both.

Ok,

Just to make it a simpler reply, what I really need is to know what the
SQL would be to update one table/price using a 2nd table's price column
where the IDs are the same in both.

Steve wrote:
> On Tue, 02 Jan 2007 13:19:24 -0600, Lee <lee_nospam_@artjunky.com>
> wrote:
>
>> I have an excel file that has a number of columns.
>>
>> I want to be able to UPDATE the Prices only in Windows SQL database.
>>
>> What's the best way to get from an EXCEL file to SQL and what would the
>> query look like?
>
> Perhaps this product is of use to you?
>
> http://www.sqlmanager.net/en/products/mssql/dataimport
>
Thanks but that's probably not the route I want to take.

On Tue, 02 Jan 2007 13:19:24 -0600, Lee <lee_nospam_@artjunky.com>
wrote:

>I have an excel file that has a number of columns.
>
>I want to be able to UPDATE the Prices only in Windows SQL database.
>
>What's the best way to get from an EXCEL file to SQL and what would the
> query look like?

Perhaps this product is of use to you?

http://www.sqlmanager.net/en/products/mssql/dataimport

--
Steve
steve at flyingtigerwebdesign dot com