Link Table to a txt 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

General SQL Server Forums

New to SQL Server Programming

Link Table to a txt file

Author

Topic

korssane
Posting Yak Master

104 Posts

Posted - 2009-03-23 : 16:56:10

Hi All,
IIOs it possible to link a Table to an existing Text file that conatins all my data?
If so how

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-23 : 17:06:36

You can import data from the text file into a table via several methods. Here are some of those methods: bcp.exe, DTS, SSIS, import/export wizard, T-SQL (xp_cmdshell).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

korssane
Posting Yak Master

104 Posts

Posted - 2009-03-23 : 20:29:44

HI Tkizer,
is there a way to link directly to a text file?
Please , is it possible to explicit ..i am a new in sql.
I am running my DB in sql 2005 express.

thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-03-25 : 04:02:29

quote:
Originally posted by korssane

HI Tkizer,
is there a way to link directly to a text file?
Please , is it possible to explicit ..i am a new in sql.
I am running my DB in sql 2005 express.

thanks

What do you mean by direct link?
Do you want to update table data whenever there are data changes in the text file?

Madhivanan

Failing to plan is Planning to fail

korssane
Posting Yak Master

104 Posts

Posted - 2009-03-25 : 14:54:33

definitely yes.
thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-03-26 : 02:33:32

quote:
Originally posted by korssane

definitely yes.
thanks

You can't link directly
Create procedure that updates data to table from file
Schedule it to run periodically

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources