Dynamic INSERT statements don't know wheather to use quotes or not
Posted on 2004-04-27
I want to make a bulk insert of data from Excel sheets. When I read from Excel I dont know
what type it is in the database, which means I don't know wheather to have quotes around
the value or not.
I create the insert statement dynamically, and it has worked for me before to always use
quotes, even around int and bit, and the data was interpreted correctly.
However it doesn't work for me now, and I have no clue how to make it work other that
to define all fields as varchar instead of int and bit.
In short, I want this to work:
INSERT INTO Table1 (vcName, inAge) VALUES ('Tobbe', '28')
Thanks for your help,