How to import a DBF file in SQL Server

by

Use a linked server or use openrowset, example

SELECT * into SomeTable
FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\SomeServer\SomePath\;
SourceType=DBF',
'SELECT * FROM SomeDBF')

More Related Contents:

  1. Export from SQL Server to Excel
  2. hide/remove header and footer
  3. How do I generate a random number for each row in a T-SQL select?
  4. Auto increment primary key in SQL Server Management Studio 2012
  5. SQL Server Linked Server Example Query
  6. Combine multiple results in a subquery into a single comma-separated value
  7. Infinite loop CTE with OPTION (maxrecursion 0)
  8. SQL Server: SELECT only the rows with MAX(DATE)
  9. Floor a date in SQL server
  10. PIVOT in sql 2005
  11. LEN function not including trailing spaces in SQL Server
  12. How FOR XML PATH(”) works when concatenating rows
  13. Scheduled run of stored procedure on SQL server
  14. SQL Server ORDER BY date and nulls last
  15. SSRS 2014 report deploy issue
  16. Best way to implement an audit trail in SQL Server?
  17. Set start value for column with autoincrement
  18. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  19. SqlDataAdapter.Fill method slow
  20. What is the Oracle equivalent of SQL Server’s IsNull() function?
  21. syntax for single row MERGE / upsert in SQL Server
  22. How to find all the dependencies of a table in sql server
  23. What happens to the primary key Id when it goes over the limit?
  24. SQL Recursive CTE: Finding objects linked by property
  25. SQL Client for Mac OS X that works with MS SQL Server [closed]
  26. Is there a way to retrieve the view definition from a SQL Server using plain ADO?
  27. T-sql – determine if value is integer
  28. Execute stored procedure with an Output parameter?
  29. Importing excel files having variable headers
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment