Update excel record to existing DBtable

[waka]

Hi, can any one help ?

i would like update my excel record into my database.i'm using this code but is not working. any advice make it work ?

sqlStatement = "Update TestDB set 2009-11-Wk1 = Select E:E From [insert$]"

[Bob Phillips]

Is this trying to insert multiple records at once, or one multi-column record?

What does the table definition look like?

[waka]

trying to update multiple records at once into my existing database. my existing database, there is data in it. i just wanted to update multiple record at once. i cant use insert statement because it will look like fig 1, only use update statement. the actual result will look like figure 3

[waka]

figure 3

[waka]

Hi, i'm trying to update using this statement but its not working.

"Update TestDB SET "
    sqlStatement = sql & "2009-11-Wk1 = '" & Worksheets("Forecast").Range("E2:E6").Value"' "