Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2003 @ 14:06:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Try this: in excel instead of: 'aaaaa' use ''aaaaa' (prefix it with 2 apostrophes)

Furthermore if you have queryman:

1) save excel file as .txt format (e.g. tab delimited)

2) in queryman->Tools->options->export tab you can set single/double quotes and delimiter (may be tab) values for import/export file

3) choose the right ones for you

4) use import clause in queryman for your insert: e.g. insert into TabName values (?, ?, ?, ?) (if you have 4 columns).

5) press F5 and queryman ask you the name of .txt file to use

Anyway, if your problem is that the first apostrophe is missing, you can use some regular expression to add it (e.g. with TextPad/UltraEdit editors).

Hope this helps

Sergio Azzaretti

	<Prev	Next>		<<First	<Prev	Next>	Last>>