Updating price list

[Newsgroup_User]

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?

[Newsgroup_User]

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

[Newsgroup_User]

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.

[Newsgroup_User]

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.

[Newsgroup_User]

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.

[Newsgroup_User]

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.

[Newsgroup_User]

Sorry, I understand

SQL Server 2000

[Newsgroup_User]

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

[Newsgroup_User]

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?