Hi, I'm pretty new to integration services and I'm trying import data from a DBF database. What's the best way to do this? We're using Windows 2008 R2 64bit with SQL server R2.
I've opened the tables on a Windows 7 32bit machine using Excel using the following method:
- Installed the 32bit Foxpro driver http://msdn.microsoft.com/en-us/vfoxpro/bb190233 - no 64bit reader
- Created a ODBC connection using 32bit ODBC
- Created a ODBC data source using the Microsoft DBase VFP driver and chose database type "free table directory"
- Open customer database in Excel (needs to be a 32bit program)
Your help would be appreciated! Thanks