Import Foxpro Data into SS2005 64 Bit 1

[gcoast]

Installed
Windows 2003 Server Enterprise Edition
SQL Server 2005 64 Bit Standard Edition
FoxPro 32 bit drivers

Question: How can I import Foxpro (version 6) data into a 64 bit SS2005. There is no "MS OLE DB Provider for Visual Foxpro" listed in the Data Source drop down when using the import/export wizard.

I know this works on a different SS2005 32bit server.


Thanks,

g

 

[Jamfool]

The ole drivers are available on a 32bit install only. You also cant create linked excel/access servers.

 

[gcoast]

Thanks for the info. When you say 32bit install are you referring to the O/S or Sql Server?

g

 

[Jamfool]

I haven't installed a 32 bit sql on a 64 bit box, but i would assume that the ole drivers would not be installed.

 

[ESquared]

so pipe them through the 32-bit install to the 64-bit install.