how do I create a job script to import excel into sql server as a sql table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

You can make use of OPENROWSET functionality available in SQL Server 2000

Also, you can do it by creating a dts package that does the importing stuff and schedule that dts package as a agent job on sql server.

Manu

wlahue-773092 SSC Enthusiast Points: 145 More actions · Answer 2

I actually did use the DTS but haven't try to save it as a job. Thanks for the help.