Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Two questions
 
From:   Azzaretti, Sergio

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023