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)
 Import/Export Wizard

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-10 : 06:50:50
Prathi writes "Hi,

I just installed Sqlserver 2000 (Personal Edition) on my laptop which is on Windows XP. When I create a database and try to import data, Microsoft excel 97-2000 is not a choice at all... I have reinstalled but nothing happened. Any insight into this is greatly appreciated. Excel 2003 is installed on the laptop.

Thanks Prathi"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-10 : 06:53:11
Microsoft's Data Access Components (MDAC) no longer include Jet drivers by default (since v2.6 I think). These drivers are used to import MS Access and Excel data. You can download them (and other MDAC drivers) here:

http://msdn.microsoft.com/data/downloads/updates/default.aspx#jet
Go to Top of Page
   

- Advertisement -