Add data into a table from an Excel file

In BaseBear you can import data from an Excel file into an existing table. So you can maintain the structure of the table and all custom permissions applied. Here's how:

  1. Enter BaseBear.
  2. Click Edit button below a database name.
  3. Click "Import from Excel" button.
  4. Choose "Append data to a table" option.
  5. Choose a table.
  6. Choose an Excel file from your computer and import.

The Excel file must have the column names the same as the BaseBear table. Also the data type must be the same, for example, you cannot import the text values in a numeric column.