question

DataJoe avatar image
DataJoe asked

How to import dbf into SQL2014 Express

I see many threads on this but I am at a loss. I have tried bcp, bulk import various ways. For one is this even possible? Compatiable? The closest I have come is to use bcp with a format file. I get truncation errors. one blog said to use bulk import and turn off ansi messaging. any suggestions as to what import type to use?
data-import
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
It's unlikely that any of the standard processes of SQL Server can read a DBF file directly. Your best bet is to use an Extract Transform and Load (ETL) tool. The one that comes with SQL Server is [SQL Server Integration Services][1] (SSIS). That can absolutely do the job. However, SSIS doesn't come with Express. It's only part of the full product. The cheapest way to get your hands on it would be to get the Developer Edition. It's only about $50. Your second choice is then to open the DBF file with the native tool that made it. Use that tool to export to a delimited text file and then use an import into SQL Server through bulk import. [1]: https://technet.microsoft.com/en-us/library/ms141026.aspx
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant: when you think about the size of SQL central thanks for speedy answer. I had this process working on full blown SQL using SSIS. Anyway to extract SSIS code and simply transport the code or is there inter-related dependent coding when using SSIS processes on SQL server? thanks again
0 Likes 0 ·
I don't think there's a way to create an executable out of SSIS. I'm pretty sure you have to have the service in order to run a package.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.