INSERT INTO Problem

P

Piotr

Hi
Im trying add records from .xls to Access file

strSQL = "INSERT INTO reports (SF,REG,DATA,SHOP,ID_PRODUCT,QTY) VALUES
(" & SF & "," & REG & "," & DATA & "," & SHOP & "," & ID_PRODUCT & ","
& QTY & ")"
rs.Open strSQL, conn
Next i
conn.Close

I recive error whole the time, something about lack of operator, what
is this ?
How should it work with access database, I have never recived such
error with PHP + MySQL.
 
Top