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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2010-09-21 : 16:12:53
|
| How come in the import\export wizard there is no data source for Microsoft.Jet.OLEDB.4.0? I am trying to import a .dbf file. Is there a way to add data sources to the drop down?Thanks for any help. I miss DTS...R/ Poser |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2010-09-21 : 16:44:50
|
| If I run the xp_enum_oledb_providers and it shows up in the list...Does it still need installed? And..how do I install it?Thanks for your help...R/P |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2010-09-21 : 16:58:08
|
| I remote into the server and open SQL Server Mgmt Studio and run it there. This is not the default instance but a named instance, if that matters.I did try on the default instance and it does not show up there either.Thanks for taking the time to help meR/P |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Data Source in Import Wizard