How to Use this Chapter

---

Although this chapter is broken into several sections, it is designed to be read from front to back sequentially.

---

Note
Depending on the complexity of your application, this chapter may require that you have substantial knowledge of the internal record structure of your Btrieve data file.

---

Before you Begin

Make Sure it's Necessary

Before you follow the instructions provided in the remainder of this chapter, you must determine whether your data file is already enabled for ODBC/relational access.

To determine whether your data file is ODBC-enabled

1. Inspect the folder or directory where your Btrieve file is currently located. If you see files named FIELD.DDF, FILE.DDF, and INDEX.DDF in this folder, then most likely your data file can already be accessed with ODBC.

---

Note
While most applications keep the DDFs in the same directory as the data files, storing them in the same location is not required. You may wish to search the same physical volume as the data files for one of the above mentioned DDF files, to be sure that you do not have DDF files available.

---

If this is the case, then you need only set up access to the database. Follow the instructions provided in Chapter 2 of Pervasive.SQL User's Guide.

Decide on Your Goal

Next, you must decide what you want to do. Do you want to build a brand new Pervasive.SQL database around an existing Btrieve file (or files), or do you want to add an existing Btrieve file as a new table in an existing Pervasive.SQL database?

If you want to do this ...	... follow these instructions:
Create a brand new database around my Btrieve file	Creating a Database
Add your Btrieve file to an existing database	Associating a Data File with a Database