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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Data Import / Enterprise Manager / Choose Data Source

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-07 : 08:26:20
eric writes "Hi,

I am using Enterprise Manager to access my SQL database.

I am looking to perform an import, but when I get to the first screen, I am asked to choose a Data Source. Usually I have the Microsoft Excel 97-2000 selection in there which I use all the time in my office - however, I am not being prompted with this option.

If I select another option, such as .txt - i can select the file to import the data, but upon clicking "next" i get no response.

In my Admin/ODBC all the drivers are listed, and its a relatively fresh install of Win XP.

Any help here would be appreciated.

Thanks!
Eric
eric@apolloaudio.com"
   

- Advertisement -