From: teddybubu@gmail.com   
      
   I need to import hundreds of data txt files to sql server 2008.   
   All the txt files are in folders.  The folders names are country names.   
   Obviously, I don't want to do this manually.   
   This is what I want:   
      
   1. import all country/folder names into sql server and create a table   
        example: dbo.China   
   2. import all txt files in country/folder to specific dbo in sql server   
      
   Is this possible to do and is it done with stored procedures??   
   How do I do this?  I am a beginner so any help is appreciated.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)