INSERT STATEMENT...help 1

[graphix03]

Hi, I'm trying to create an insert
sql statement in a form in vb6.

the insert statement works for rest
but not for the column where its
the value is: Insurance Company.

I tried

insert....
'" & [Insurance Company] & "',"
....
but it keeps gives error message of Type Mismatch.

what is wrong with it? any input would be greatly
appreciated.

 

[graphix03]

Never mind, i just got it. thank you.

 

[Golom]

The Value is "insurance company" or the field name is "insurance company"?

if it's value

INSERT INTO tbl ( fldname ) VALUES ( 'insurance company' )

if it's field name

INSERT INTO tbl (insurance company) VALUES ( 'BIG Insurance Corp.' )

 

[graphix03]

Thanks Golom, you're right. thanks for your input.