DBF file table structure to create table in SQL server

Question

I am trying to migrate DBF files to MS SQL Server 2008. While importing files from SQL Server Import And Export Wizard. I am unable to import the files. I have created the connection. But when I try to Edit Mappings/ Preview the table It shows error "External table is not in expected format"

Anyhelp would be appreciated.

This looks like a reprise of this question stackoverflow.com/questions/7879436/… ... Common factor: your DBF files appear to be unconventional. Try publishing a sample file on the web so that it can be diagnosed. — John Machin
– John Machin, Commented Oct 28, 2011 at 23:52
@JohnMachin : No the data I am working on is kinda confidential. So I can't upload it on web. — NinjaCoder
– NinjaCoder, Commented Nov 7, 2011 at 16:38
So consider making it available under an NDA. A Google search for "john machin xlrd readme" will find my email address. — John Machin
– John Machin, Commented Nov 7, 2011 at 19:37

Philip Kelley · Accepted Answer · 2011-10-26 22:41:31Z

1

If you can't get the wizard to work, you'd have to write your own code, using linked servers or OPENROWSET. If you are new to SQL Server, linked servers and OPENROWSET are about the last thing you want to have to figure out.

Once upon a time long long ago, I wrote drivers in Foxpro that read data from and wrote data to SQL Server tables. This would have been SQL Server 7.0, and I was probably using OLE DB. If SQL can't talk to Foxpro (which wouldn't surprise me), you may need to get Foxpro to talk to SQL.

Failing that, dumping from Foxpro to some form of text delimited file and then importing them will work, though it'd take more effort.

answered Oct 26, 2011 at 22:41

Philip Kelley

40.5k11 gold badges62 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frank Perez · Accepted Answer · 2011-10-27 16:43:08Z

0

I would recommend using SQL Bulk XML Load to move data from DBF tables to MS SQL Server. Doug Hennig wrote a blog post here with sample code.

answered Oct 27, 2011 at 16:43

Frank Perez

9938 silver badges18 bronze badges

Collectives™ on Stack Overflow

DBF file table structure to create table in SQL server

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related