I have installed SQL Server Managemert Server Express .... I am wondering how to import data from an excel spreadsheet?
.. Silent Running
hi,
you "traditionally" use a linked server to perform that kind of operation, but, if you install the DTSWizard from the Microsoft SQL Server 2005 Express Edtion Toolkit, you have some kind of user interface for that as well..
regards
|||I download the toolkit but i didn't see any thing about a dtswizard
|||hi,
no shortcut is created for it... but have a look in \Program Files\Microsoft SQL Server\90\DTS\Binn\dtswizard.exe ..
regards
