How to data import from DBF file to sql server 2005 using c# .net?

Question

Sam Hobbs · Answer

Are you sure you must write a C# program? SQL Server has many utilities. Is this for a one-time import or does the import need to be done many times in the future?

Shankey · Answer

hi shanmugam Try following steps in sql server management studio 1. Right click on Databases 2. Select Attach... 3. Click add button of Attach databases dialog box 4. browse your .mdf file in Locate database files dialog box and click ok 5. now click ok button on Attach databases dialog box