Currently i use
rst.Open "Insert into OperatorDetail ([Digital Subscribers], [Platform], [Country]) VALUES (" & temp2 & " , 'CABLE' , '" & temp & "')", conn
to insert data into a table, the only problem is that when i update the table from my excel worksheet it creates duplicate files

if i use update it will not create new entries where they currently do not exist..

i need a overwrite command that also creates a new record where an old is not found!

can i use a update where (blablabla) and if these conditions are not met then insert?


thanks guys,


Jonathan