DTS IMPORT TO SQL FROM EXCEL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS IMPORT TO SQL FROM EXCEL

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-21 : 09:50:18

Ammar writes "hi i have import an excel sheet through DTS and name it as MARKDOWN (TABLE NAME)

i have an other table in DATABASE which i want to update. name is Markdown_details

the field i want to update in MARKDOWN_DETAILS
is NEW_SP
and the field name in imported table is SALE

how can i do it the query i want is

UPDATE MARKDOWN_DETAILS
SET markdown_details.NEW_SP = markdown.sale
where markdown_details.PRODUCT_NO_STRING = markdown.PROD_CODE
and markdown_id = 734

but this query doesnt work can you please correct me.
Regards,"

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2006-06-22 : 00:48:13

Hi,
Try this query..
UPDATE MARKDOWN_DETAILS
SET markdown_details.NEW_SP = markdown.sale
from markdown
where markdown_details.PRODUCT_NO_STRING = markdown.PROD_CODE
and markdown.markdown_id = 734

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources