Autoimport from xls to SQL 2000?

microsoft.public.sqlserver.tools

16 Feb 2007 10:18 PM

Cwhitmore

I have a program setup the exports check request data into a xls file every
week on a shared directory on Windows 2003 server. I'd like a way to import
that data into SQL 2000 on a weekly basis. (Shared directory and SQL on same
server).
Ideas?

19 Feb 2007 12:07 AM

Immy

just create a dts job to do it.

Show quote

"Cwhitmore" <Cwhitm***@discussions.microsoft.com> wrote in message
news:42DDB5A3-0F75-4ABE-B7D5-CBA86251AC6C@microsoft.com...
>I have a program setup the exports check request data into a xls file every
> week on a shared directory on Windows 2003 server. I'd like a way to
> import
> that data into SQL 2000 on a weekly basis. (Shared directory and SQL on
> same
> server).
> Ideas?
>