Hi
Please take a look at the example given
I have a whole list of fields that I wish to combine into a certain string,
As there are too many fields including all the , ' ; etc Concantate may not be able to do it ....
Hi
Please take a look at the example given
I have a whole list of fields that I wish to combine into a certain string,
As there are too many fields including all the , ' ; etc Concantate may not be able to do it ....
Re: Combine these fields to form a SQL string
This is not difficult. I haven't done it all, but here is the beginning:
="INSERT INTO 'games' VALUES ("&A2&", '"&B2&"', '"&C2
which gives
INSERT INTO 'games' VALUES (1000, 'African Mask', 'A challenging puzzle game
Carry, noting that numeric fields do not need the single quotes, but text fields do.
Don’t have an account yet? Register yourself now and be a part of our community!