Oct 2, 2001 #1 hideaki25 MIS Joined Oct 1, 2001 Messages 6 Location 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 Joined May 9, 2001 Messages 349 Location 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 Joined Oct 1, 2001 Messages 6 Location JP Thanks so much for your help. Upvote 0 Downvote