<p>How can you import a foxpro DBF file in SQL Server?</p>

[{'answer_id': 52828, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 5, 'selected': True, 'text': "<p>Use a linked server or use openrowset, example</p>\n\n<pre><code>SELECT * into SomeTable\nFROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;\nSourceDB=\\\\SomeServer\\SomePath\\;\nSourceType=DBF',\n'SELECT * FROM SomeDBF')\n</code></pre>\n"}, {'answer_id': 52835, 'author': 'GateKiller', 'author_id': 383, 'author_profile': 'https://Stackoverflow.com/users/383', 'pm_score': 0, 'selected': False, 'text': '<p>This tools allows you to import to and from SQL Server.</p>\n\n<ul>\n<li><a href="http://www.download3000.com/download_17933.html" rel="nofollow noreferrer">http://www.download3000.com/download_17933.html</a></li>\n</ul>\n'}, {'answer_id': 6346611, 'author': 'jnovation', 'author_id': 798044, 'author_profile': 'https://Stackoverflow.com/users/798044', 'pm_score': 2, 'selected': False, 'text': '<p>What finally worked for us was to use the <a href="http://www.microsoft.com/download/en/details.aspx?id=14839" rel="nofollow">FoxPro OLEDB Driver</a> and use the following syntax.  In our case we are using SQL 2008.</p>\n\n<pre><code>select * from \n    openrowset(\'VFPOLEDB\',\'\\\\VM-GIS\\E\\Projects\\mymap.dbf\';\'\';\n    \'\',\'SELECT * FROM mymap\')\n</code></pre>\n\n<p>Substitute the <code>\\\\VM-GIS...</code> with the location of your DBF file, either UNC or drive path.  Also, substitute <code>mymap</code> after the <code>FROM</code> with the name of the DBF file without the .dbf extension.</p>\n'}, {'answer_id': 6452657, 'author': 'Stan', 'author_id': 812017, 'author_profile': 'https://Stackoverflow.com/users/812017', 'pm_score': 2, 'selected': False, 'text': '<p><a href="http://elphsoft.com/dbfcommander.html" rel="nofollow">http://elphsoft.com/dbfcommander.html</a> can export from DBF to SQL Server and vice versa</p>\n'}, {'answer_id': 11973558, 'author': 'mark d', 'author_id': 1601157, 'author_profile': 'https://Stackoverflow.com/users/1601157', 'pm_score': 3, 'selected': False, 'text': "<p>I was able to use the answer from jnovation but since there was something wrong with my fields, I simply selected specific fields instead of all, like:</p>\n\n<pre><code>select * into CERTDATA\nfrom  openrowset('VFPOLEDB','C:\\SomePath\\CERTDATA.DBF';'';\n    '','SELECT ACTUAL, CERTID,  FROM CERTDATA')\n</code></pre>\n\n<p>Very exciting to finally have a workable answer thanks to everyone here!</p>\n"}]
['https://Stackoverflow.com/questions/52822', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4685/']