From: esquel@sommarskog.se   
      
   tad na (teddybubu@gmail.com) writes:   
   > All txt files have the same column structure so that is a big relief.   
   > I like the idea of creating one table but the problem is each txt file   
   > does not have a column with the country name.  How can I insert a new   
   > column with the country name when importing to sql server?   
   >   
      
   The program that controls the load, would real the file and add the country   
   name when inserting the rows. If you use BCP/BULK INSERT, you would have to   
   change the default before each file.   
      
   There are plenty of options available, and which one you chose is largely   
   up to your skills. That is, if you know C#, you write a C# program. If   
   you VBscript you do it VBscript etc.   
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)