Oct 2, 2001 #1 hideaki25 MIS Oct 1, 2001 6 JP I'm wondering if SQL Server has the capability to import in Excel files such as Access can import in Excel files as tables. If so can you outline the general steps ? Thanks !
I'm wondering if SQL Server has the capability to import in Excel files such as Access can import in Excel files as tables. If so can you outline the general steps ? Thanks !
Oct 2, 2001 #2 RickCole Technical User May 9, 2001 349 GB If your runing SQL Server 7.0 or later you can use DTS. The following link should get you started. http://www.sqldts.com/default.asp?nav=1,1,1,100 Rick. Upvote 0 Downvote
If your runing SQL Server 7.0 or later you can use DTS. The following link should get you started. http://www.sqldts.com/default.asp?nav=1,1,1,100 Rick.
Oct 2, 2001 Thread starter #3 hideaki25 MIS Oct 1, 2001 6 JP Thanks so much for your help. Upvote 0 Downvote