Hello,
I connected my Excel to Access table (table name : "Main") and when i enter to OLE DB window i can see my sql query ("select * from main;").
I would like to know how can i insert new row (from Excel) to my Access table.
I tried this : "insert into main (code, sum) values (10 , 18);" but this does'nt work.
I have already action query in Access but i don't know how to run this query from Excel.
Someone maybe knows what the code?
Thanks.