Hi,

I'm trying to insert data from a worksheets into a sql database over an ADODB connection. I can get the connection to work but I keep getting a run time error 438 Object doesn't support this property or method. I thin kit is the sql query that is the problem but I can't figure it out. I've attached a screen shot of the datasheet I'm using with some test data and I've removed the connection details from the code. Any ideas?Capture.PNG

Please Login or Register  to view this content.