all groups > sql server new users > november 2006 >
You're in the

sql server new users

group:

Import a csv into existing table


Re: Import a csv into existing table Otis Mukinfus
11/28/2006 12:00:00 AM
sql server new users:
[quoted text, click to view]

With SQL Server 2005 you would use Integration Services.

In Programs navigate to: Microsoft SQL Server 2005/SQL Server Bushiness
Intelligence Development Studio.

They sure made that easy to find didn't they? ;o) Seems they would use the
words "Integration Services" somewhere.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
Import a csv into existing table Irene
11/28/2006 2:16:33 AM
I have a table containing data. I need to append some more data from a csv into the same table. I would have used DTS on sql server 2000 but I cannot see how to achieve the same with sql server 2005.

Any ideas?

EggHeadCafe.com - .NET Developer Portal of Choice
Re: Import a csv into existing table Arnie Rowland
11/28/2006 8:23:09 AM
Right-click on the database, select [Tasks], and click on [Import Data].
Follow the prompts and supply the appropriate information.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

AddThis Social Bookmark Button