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 2005 Forums  Transact-SQL (2005)  SQL Query to read in data from a DBF file.

Author  Topic  jgoeke Starting Member 1 Post Posted - 2009-09-23 : 12:54:41 I have been trying for days unsuccessfully trying to find a way to run a SQL query to read in data from a dbf file. I can open the file (named punch.dbf) just fine using excell, and the tab for the sheet is called "PUNCH", and see all the data just fine. The file was generated by a time punch card system and then exported to this dbf file. After many tries of using openrowset and opendatasource, the closest I think I have come is using the following command from a SQL Query window. SELECT * FROM OPENDATASOURCE( 'sqloledb', 'Driver=Microsoft FoxPro VFP Driver;SourceType=DBF;SourceDb=C:\work\vantage\punchcard\punch.dbf;User Id=D3;Password=vantage' )...PUNCH The error I am getting is: "Server: Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "(null)" does not contain the table "PUNCH". The table either does not exist or the current user does not have permissions on that table." I have had a very hard time finding any documentation on any of the providers for either the openrowset or opendatasource, especially for the dbf file format. Any help is appreicated! Thanks in advance! ---JHG ---JHG