Posts Tagged ‘.DBF’

18
Jun

Cialis Price In Canada

by Lynn Demarest in SQL Server, Technical

Viagra en gel UPDATE: I learned today that you can sometimes open .DBF files with Excel. Viagra en gel If you can do this, viagra en gel it will be easier than the method described below. Viagra en gel Simply open the .DBF file, viagra en gel then save it as a .CSV and import the .CSV into SQL Server.

Viagra en gel  

Viagra en gel I received a .DBF file the other day that contained a bunch of data in which I was interested. Viagra en gel I don’t have DBase anymore (who does?) so I wanted to import the data into MS SQL Server so I could write queries against it.  But how to accomplish such an import? There’s no option to import a .DBF file directly.

Viagra en gel The solution was ODBC. Viagra en gel Here’s how to do it:

1. Viagra en gel Create an ODBC connection to the .DBF file

  1. Find Data Sources (ODBC) in the Control Panel‘s Administrative Tools.
  2. Select the System DSN tab and click Add
  3. Select Microsoft DBase Driver (*.dbf)
  4. Click Finish
  5. Enter a Data Source Name (no spaces)
  6. Un-check Use Current Directory
  7. Click the Select Directory button and navigate to the folder that contains the .DBF file

Viagra en gel Your  .DBF file is now ready to be accessed via ODBC.

2. Viagra en gel Import the .DBF data into SQL Server

  1. Open Microsoft SQL Server Management Studio and create a new database
  2. Right-click the database name, viagra en gel select tasks and import data.
  3. The welcome screen will open. Viagra en gel Click Next.
  4. Select the data source
    Because we’re moving data into SQL Server from .DBF, viagra en gel the .DBF file is our source.
    Select .Net Framework Data Provider for Odbc
  5. In the Dsn area, viagra en gel enter the DSN (data source name) you just created.
  6. Enter ODBC for the Driver. Viagra en gel (The ConnectionString should be created for you.)
  7. Choose the destination SQL Server. Viagra en gel (This should already be the database you set in step 2, viagra en gel above.)
  8. You will only be able to select Write a query to specify the data to transfer. Viagra en gel Click Next.
  9. Your query is select * from [filename.dbf] where [filename.dbf] is the name of the file the ODBC connection points at. Viagra en gel (Do NOT enter the brackets!)
  10. Change the name of the destination table so that it makes sense. Viagra en gel It will default to “Query”
  11. Click Finish to execute the data transfer

Viagra en gel  

Viagra en gel  

Average Rating: 4.5 out of 5 based on 174 user reviews.