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?
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] (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. :