To upload data into a database using the import feature, you can prepare a .CSV file in Microsoft Excel. There are two options to achieve this:
- Utilize the Power Query feature in Microsoft Excel (see below for details).
- In case of any issues or if you have an older version of Microsoft Excel, you can use the Text Import Wizard (see below for details).
Please note that this tutorial only outlines the necessary steps to enable database import in BRYTER. For more comprehensive assistance with MS Excel, please refer to the Excel Help & Training documentation.
Note that Microsoft Excel automatically automatically sets the delimiter (the character that separates values) based on your system's regional settings when saving a file as .CSV. Therefore, when importing the .CSV file into your database, it's important to choose the appropriate delimiter to ensure the data is correctly parsed and imported.
Prepare .CSV file via Excel Power Query
To prepare a .CSV file for upload into your BRYTER database, follow these steps:
- In your BRYTER database, go to the DATA MANAGEMENT page and download the .CSV file by clicking the Export data icon .
- In Excel, open a blank workbook, navigate to Data, and click on Get Data (Power Query).
- You will be prompted to choose a data source. Select Text/CSV, upload the file exported from the BRYTER database, and click Next.
- Preview the file, and if the formatting is not correct, select a different delimiter from the dropdown field.
- Click Load.
- Edit and modify the data as needed.
Avoid changing fields in the header row, as this can cause import failures.
- Save the file as .CSV. Return to your BRYTER database and import the prepared .CSV file.
Prepare .csv file via Excel Text Import Wizard
If the previous approach did not work for you, you can try this alternative method to prepare a .CSV file for upload into your BRYTER database:
- In your BRYTER database, navigate to the DATA MANAGEMENT page and download the .CSV file by clicking the Export data icon .
- In Excel, open a blank workbook, navigate to Data, and click on the Angle down icon next to Get Data (Power Query). From the dropdown list, select From Text (Legacy). Alternatively, click File > Import.
- Choose and upload your exported file. The Text Import Wizard will open.
- Walk through the steps by clicking Next. Any changes you make will be reflected in the preview. Ensure proper formatting of your data.
- Finally, click Finish and select where you want to put the data in Excel.
- Edit and modify the data as needed.
Avoid changing fields in the header row, as this can cause import failures.
- Save the file as .CSV. Return to your BRYTER database and import the prepared .CSV file.
This alternative method may work better for your specific needs in preparing the .CSV file for import into your BRYTER database.