Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cedubose
Starting Member
22 Posts |
 Posted - 2006-05-05 : 12:56:16
|
| I am attempting to import an Access file to my database using Management Studio (right click on database, "Tasks","Import Data...").It gets to the point of actually executing the import, and then comes up with this error:Could not set up data flow connections.The connection type "OLEDB" specified for connection manager [very long hex number] 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.I then exported the table to an Excel file (in Access) and tried to import that into SQL Server. I get the exact same error, only with the connection type as "EXCEL".Something is seriously wrong with my import function. Only a subset of the normal connection types is present in the dropdown list. Notably missing is "text file".Is there something I have to set up in Management Studio to activate these connection types?Cynthia |
|
|
cedubose
Starting Member
22 Posts |
Posted - 2006-05-05 : 14:10:38
|
| Google is my friend ...I found this thread in an MSDN forum that resolves this problem --http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=4&SiteID=1&PostID=363238Apparently the problem is, certain third-party programs that are installed adversely impact the permissions on certain registry entries. Changing the permissions on those entries solves the problem. I even have "text file" back!Cynthia |
 |
|
|
|
|
|
Problem importing Access, Excel using SQL 2005