Update query help

[fehmi]

INSERT INTO FATURA1
SELECT *
FROM [\\Kaca1\barkod\barkod].fatura1;


this query need as update query

 

[plog]

Update means you are changing existing records. What records and what fields of those records do you want to change exactly?

 

[Taruz]

Merhaba Fehmi..

seems to have a connection problem..:

try this way..:

INSERT INTO FATURA1
SELECT *
FROM fatura1 in '\\Kaca1\barkod\barkod.mdb'


mdb extension is assumed..

 

[fehmi]

Update means you are changing existing records. What records and what fields of those records do you want to change exactly?

HI,
that append query work properly, but I need to update table "fatura1"
from database in first computer "kaca1", to second computer "kaca2".
first "barkod" is folder, second "barkod" is name of database, "fatura1" is table.

thanks.

 

[fehmi]

HI,
that append query work properly, but I need to update table "fatura1"
from database in first computer "kaca1", to second computer "kaca2".
first "barkod" is folder, second "barkod" is name of database, "fatura1" is table.

thanks.

I have attempted this:

update fatura1
from [\\kaca1\barkod\barkod\fatura1
where price>0;

without succes.