asked on

INSERT INTO STATEMENT - - Syntax

Using a table with 24 fields (both number and text fields) is there a limit in length of Insert Into Statement (it takes 2 lines), and what is the proper syntax? (Attempted a variety of ways - no success, get a Syntax Error in INSERT INTO Statement)

anthonyc

insert into table1(column1, column2, column3, column4, ..., column24) values(value1, value2, value3, value4, ..., value24)

cbugler

ASKER

I know the basic syntax for the statement. The problem may be the length or the number fields. We use '" & value & "', not sure if there is a better option for the number fields. Also the field names are rather long, is there a limit in the total number of characters allowed in the total of field names (not one name).

anthonyc

oh well, figure it out yourself.. You said you needed syntax, I gave it, and now I am wrong.

cbugler

ASKER

cbugler

ASKER

AnthonyC

Sorry if the rejection of your answer offended you. I'm looking for an answer to my question not an arguement. Yes you gave me the basic syntax and your right, and tha'ts the way I have been doing it, but I am still getting an error, so I was looking for more detail and an answer regarding the length of the statement.

deighton

Do you need to wrap your field names in [] ie [field name1]

Just a thought!

cbugler

ASKER

Thanks deighton.

ASKER CERTIFIED SOLUTION

deighton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial