I have to import DBF files into a SQL Server 2005 db. I'm using a linked server to query the files directly, however certain files keep throwing errors at me. I've since discovered that the problematic files are Dbase7. The others are all Dbase3/5.
The problem:
1. Using Microsoft.Jet.OLEDB.4.0 Driver
1.1. EXEC sp_tables_ex <LinkedServer>
Retrieves all tables in the linked server directory (including Dbase 7 tables)
1.2. Select * From <LinkedServer>...<DBase7 DBF>
"OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server <LinkedServer> returned message "External table is not in the expected format.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server <LinkedServer>. The provider supports the interface, but returns a failure code when it is used."
2. Using Visual FoxPro VFPOLEDB Driver
1.1. EXEC sp_tables_ex <LinkedServer>
Retrieves all tables in the linked server directory except Dbase 7 tables
1.2. Select * From <LinkedServer>...<DBase7 DBF>
The OLE DB provider "VFPOLEDB" for linked server <LinkedServer> does not contain the table <Table>. The table either does not exist or the current user does not have permissions on that table.
Anyone have any ideas?
Query Dbase7 DBF using linked server in SQL Server 2005
-
- Registered User
- Posts: 636
- Joined: 01 Feb 2006, 02:00
- Location: Cape Town
Query Dbase7 DBF using linked server in SQL Server 2005
xchuckx has been flushed and respawned neo-nymbo