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
 Import/Export (DTS) and Replication (2000)
 reading text files into a table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-29 : 07:55:19
femi writes "i am developing an application whereby another application will drop txt files in a directory.
The txt files will have the creationdate appended to the end of their file names so there is no standard 'one' file that i will look 4 to import data.

how can i create a stored procedure to achieve this i.e. ijust want to upload the data in any file i find in that predetermined directory..
i'm assuming that the data formats are compatible with the tables i am importing the data into..

sql server 2000 /windows 2000 pro"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-07-29 : 07:57:00
This might help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24371

There are ways to do it in DTS too, if someone doesn't post the code here you can try:

http://www.sqldts.com/
Go to Top of Page
   

- Advertisement -