SQL Server Performance Forum – Threads Archive

Importing Excel in SQL

Hello All, I know nothing about SQL. I got thrown into this mess. One of the people in my office that uses SQL is trying to import Excel. as soon as she clicks on Excel from the drop down menu she gets an error. (see below) As I have no clue I was hoping someone here could help. We have uninstalled SQL and reloaded it, reinstalled SP2, reinstalled office and it still has the same problem. Thank You in advance.
TITLE: SQL Server Import and Export Wizard
—————————— An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ——————————
ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) —————————— The connection type "EXCEL" specified for connection manager "{3952004B-8EC8-4D11-A7B2-228AAB62B7A7}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({26D3DA6B-F216-4D87-B36F-8C0E56EC26F7}) —————————— The connection type "EXCEL" specified for connection manager "{3952004B-8EC8-4D11-A7B2-228AAB62B7A7}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({26D3DA6B-F216-4D87-B36F-8C0E56EC26F7}) ——————————
BUTTONS: OK
——————–

Ok Few things you need to consider. 1) Makes sure that Excel file has clearing columns defined.
2) Do you have a table in SQL to where you want to transfer the data too?
3) If not, then you will have to use DTS Import Wizard. It can be located Tools>Wizards>Data Transformation Services. 4) Save that excel files as an CSV file.
5) Import that CSV file inside SQL . I hope this helps. Thanks.

Thanks smartrider, But it doesnt even get that far. As soon as she clicks on Excel from the drop down menu the error comes up. It does not even get to the screen to select a file to import.
Esanders

Hi,
In 2005,
To import excel file into SQL table you can take the SSIS import?export Wizard help. Open a new Integration project through Visual Studio 2005.
In VS window, under Project Menu, you can select SSIS Import/Export Wizard Option and follow the ongoing steps to import the Excel file

Thanks ranjitjain. I have her looking into it now. I will post results when she gets back to me. Thanks again

Ok she tried that and it comes up with different errors.

It would be helpful, if you could post the error messages your coworker is getting. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

]]>