Hi,

I do not know whether I can ask this question here or not. But I am facing this problem and need help from the experts.

I have a table called Properties_tab which contains oracle sql queries like this: Name query sql1 Select * from abc sql2 select col1 "name", col2 "address" from abcd where col3 = 123 Sql3 select col1, nvl(col2,0), col3 from abcde where col4 = 'abcd'

The team gave us this data into an excel file for Teradata conversion. we converted into Teradata. After converting I am trying to upload them into the Teradata. I do not want to do an manual update or insertion. I am trying to do in sql assistant- file- Import data. So it is looking for a tab delimited.

I tried converting the excel file into tab delimited and it is showing like this. sql1 "Select * from abc" sql2 "select col1 ""name"", col2 ""address"" from abcd where col3 = 123" sql3 "select col1, nvl(col2,0), col3 from abcde where col4 = 'abcd'"

and it is inserting with double quotes into the table. I do not want to insert with double quotes in table. Manual inserts works good like this Insert into Properties_tab(name, query) values ('sql3','select col1, nvl(col2,0), col3 from abcde where col4 = ''abcd''')

Any help in this would really appreciate to avoid the manual updates or insertion.

Thanks and Regards, TDHelp