Hi, I am trying to import data from a text file using a SQLAssitant. But it is giving me an error as the string contains ",".
I am using this below syntax for inserting:
ok. I got the temporary solution. Because we dont get pipe in the actual data. So, I saved the file with '|' as delimiter. then I changed the delimiter from comma to a pipe in TDA.
I didn't test it, but did you try to set "enclose column data in" in options -> import/export to "single quotes"?
No, Dieter. I did not try before.
I tested it now. It is working by selection option: Enclose column data in "Single Quotes". Thank you!
I tested with above sample code. It's working. But I am not sure if i can use this same techincque for actual file because I have 50 columns in actual file. I need to put single quote to all 20 to 30 records and 50 columns.