Creating a Table From Import

This article describes the steps needed to create a table via import from a CSV (Comma Separated Values) file.

The purpose of a database is to store information; the place where data is stored is called a table. A table consists of rows and columns. A row, also called a record, contains information about each item you are tracking in the table. A column, also known as a field, stores each characteristic tracked in the table.

Here is an example of a simple database table, containing company information. The first row, listed in bold, contains the names of the table columns:

Include header information in the first row of your CSV file, as this aids in setting up the columns in the table.

To create a table via import, follow these steps:

1. Select Tables from the primary toolbar
2. Select Import from the secondary toolbar
3. Browse for the CSV file containing information to import
4. Check the box ‘first row contains header information’, if the import file contains header information.
5. Select Create a new Table
   • Fill-in Table name:
   • Fill-in the RID Column:
6. Click Next
7. Check fields that required
8. Click Finish
9. Select OK