DBACCESS Impossibility?????
Is what I am trying to do impossible in DBACCESS??
I have a file with two columns, (name, cus_no)
I have a table with 50 columns, three of which are ( name,
cus_no,number)
I want to update the rows in the table with a number if the name and
cus_no are the same from the file.
I tried
create temp table mark
(mname integer,mcus_no integer);
load from file insert into mark;
update customer
set number = 100
where
name = mark.mname and
cus_no = mark.mcus_no
This does not work. It says no table named mark in query. Any
suggestions?????
Thanks
Mark