Groups > comp.databases.ms-sqlserver > #1751

load multiple txt files to sql server

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> (permalink)
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

Show key headers only | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-23 19:42 -0700
  Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-24 09:45 +0200
    Re: load multiple txt files to sql server bradbury9 <ray.bradbury9@gmail.com> - 2014-05-24 04:20 -0700
      Re: load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-24 09:32 -0700
        Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-24 21:57 +0200
          Re: load multiple txt files to sql server bradbury9 <ray.bradbury9@gmail.com> - 2014-05-25 03:21 -0700
      Re: load multiple txt files to sql server rja.carnegie@gmail.com - 2014-05-24 15:30 -0700
        Re: load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-24 20:50 -0700
        Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-25 11:16 +0200

csiph-web