Importing Data From Text File - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Importing Data From Text File

Author

Topic

mavsar
Starting Member

1 Post

Posted - 2003-02-18 : 05:12:27

Hello dear friends. I am new on SQL Server. I have 2 question.

1-I want add some value from text file to my table. But ?

Example;My text file contents :
U.S.A;Developer;124
India;Developer;125
Turkey;Engineer;180
.... .... ...
my table fields:
country, job,empno

2- I am running on Query Analizer. I want adding variable value from user. For example;

declare @name varchar(30)
set @name='Sharon'

I want 'Sharon' value user is input on Query Analizer.
what can i do?

thanks,
Note : I am using SQL Server 2000 Enterprise

nr
SQLTeam MVY

12543 Posts

Posted - 2003-02-18 : 06:38:13

1. Look at bulk insert in bol.

2. ???
Do you mean you want a user interface? Then you will need to build an application.
If not then what do you want to do with @name.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources