Base can import data from files containing SQL statements or delimited text files (also called CSV files).
To begin importing:
- Click the Import button in the toolbar, or
- Choose File > Import… from the menu bar
Importing from an SQL file
- Select the SQL tab of the importing sheet
- Use the Browse… button to select an existing file containing SQL statements
- Click Import… to begin the importing the contents of your selected file
Importing delimited text
- Select the CSV tab of the importing sheet
- Use the Browse… button to select an existing file containing your delimited data to import
- Enter the character used as a delimiter in the selected file
To import into a new table:
- Enter a name for the new table
- Click Import… to begin importing the contents of your selected file
To import into an existing table:
- Choose an existing table from the list
- Select which existing columns correspond to columns being imported
- Click Import… to begin importing the contents of your selected file