X-Received: by 10.66.173.75 with SMTP id bi11mr4395565pac.4.1400899363027; Fri, 23 May 2014 19:42:43 -0700 (PDT)
X-Received: by 10.182.66.73 with SMTP id d9mr53123obt.10.1400899362873; Fri, 23 May 2014 19:42:42 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!c1no15600970igq.0!news-out.google.com!qf4ni12358igc.0!nntp.google.com!hl10no4737562igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Fri, 23 May 2014 19:42:42 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=162.219.230.229; posting-account=1BSfbAoAAADPEPNpYGSQDee4_67fTiEa
NNTP-Posting-Host: 162.219.230.229
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a76c710f-76e8-4cfd-b098-9f0d3a2e5897@googlegroups.com>
Subject: load multiple txt files to sql server
From: tad na <teddybubu@gmail.com>
Injection-Date: Sat, 24 May 2014 02:42:42 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1751

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.