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
 SQL Server Administration (2000)
 Automatic DataLoading

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-06 : 17:54:20
John Felix writes "Hi,

I have one table in the database called fileloc. The structure of the table is like this :

Filelocid int (PrimaryKey),
SourceFolder varchar(100),
Nextduedate datetime;

I have to load data from the flat files (Excel,CSV,Text) stored in the Sourcefolder to the database at the date and time specified in the nextduedate column. Is there any way in SQL Server, to accomplish this task so that the data in the flatfiles get loaded into the database automatically at the specified time.

If you find any way to do this, please send a mail to me immediately.

Thanks and Regards,
John"
   

- Advertisement -