Import Multiple DBF files in SQL

Question

I have 327 .DBF files that i need to import in one table in a database in Mircosoft SQL server. These files all have the exact same structures, and are in the same location. Each file contains between 10,000 and 120,000 records.

I have been told that the easiest way to do this is to automate a conversion of all files to .txt then create a batch to merge all .txt files then import using the wizard.

Is there a way i can write a SP or other to just import the DBF files directly?

If so would appreciate some help.

Thanks

WHAT concrete database are you talking about? SQL is just a query language - used by many database systems, and they all have different approaches on how to import foreign data. So please update your tags with the appropriate database system (and version) you're using - be it MySQL, Postgres, SQL Server, Oracle, db2 or whatever else you might be using. .... — marc_s
– marc_s, Commented Jan 22, 2014 at 6:10

Oleg · Accepted Answer · 2014-01-22 07:10:47Z

1

You can use DBF Commander Pro for your task.

Open a DBF file, click File -> Export to DBMS. At the window appears Build the connection string and select the target table of the database to export data to. At the bottom of the window you'll see command line for the current export process: load DBF to database

If you click on Export button then current DBF file will be exported to the database. But since you need to export 327 files, it's better to use a command line (BAT file) for this. So, you can create such BAT file, where every of DBF files will be exported with the command line you've got in a loop. E.g.:

dbfcommander.exe -edb "D:\Data\*some_filename*.dbf" destination_table "Provider=SQLOLEDB.1;User ID=user1;Initial Catalog=test_db;Data Source=test_server"

More info on export process you can find here. DBF Commander Pro using is described here. The app has 20 days fully-featured trial period, so you can perform your task absolutely for free.

answered Jan 22, 2014 at 7:10

Oleg

8136 silver badges5 bronze badges

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

1 Comment

user2446846 Over a year ago

Thanks a tone Oleg, works perfectly. Didn't even take that long.

Collectives™ on Stack Overflow

Import Multiple DBF files in SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related