update or insert into question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

segue - 15 Mar 2008 01:28 GMT

Using MSQL SMS:

Table one: access db.
Table two: remote sql db table.

Using the import export wizard:

I'm trying to do something like this w/o the sql parse error if possible:

UPDATE [Enterprise].[dbo].[Customers]
SET [Enterprise].[dbo].[Customers].[Enterprise].[dbo].[CustomerSalesPerson]
= [Access Customer].[Access SalesPerson]
FROM [Enterprise].[dbo].[Customers], [Access Customer]
WHERE [Enterprise].[dbo].[Customers].[Enterprise].[dbo].[CustomerID] =
[Access Customer].[Access CustomerID]

Syntax appreciated - thanks.

Reply to this Message

Linchi Shea - 15 Mar 2008 05:27 GMT

I don't understand what you are asking.
For instance, what is
[Enterprise].[dbo].[Customers].[Enterprise].[dbo].[CustomerSalesPerson]
supposed to mean?

Linchi

> Using MSQL SMS:
>
[quoted text clipped - 13 lines]
>
> Syntax appreciated - thanks.

Reply to this Message

segue - 17 Mar 2008 17:37 GMT

I was just trying to emulate the wizards' idea of tablenames.

It could be (I think):

UPDATE Customers
SET Customers.CustomerSalesPerson = [Access Customer].[Access SalesPerson]
FROM Customers, [Access Customer]
WHERE CustomerID = [Access CustomerID]

I'm just trying to insert or update specific columns and tables
using thesql server import and export wizard.

Wondering what syntax I could use.

> I don't understand what you are asking.
> For instance, what is
[quoted text clipped - 20 lines]
> >
> > Syntax appreciated - thanks.

Reply to this Message