Columns are initially automapped based on their name. Clicking a column and then pressing Command-A will do a select all. You can select multiple columns at a time by holding the shift key or command key as you would a list of files in Finder. You can selectively import any number of columns.

To map the columns in the file to the columns in the destination table, simply select and drag the columns you want to import next to the table columns in the вЂњColumns to ImportвЂќ list. If the file does not have column headers, Querious will list columns by number and also display the first few characters of the field values of the first row for you to differentiate them by. In Querious, this is done with a simple drag-and-drop interface. A preview is displayed at the bottom of the sheet to help you determine if the format settings are correct.ДЄfter specifying the format settings and click on the вЂњNextвЂќ button, you then need to explicitly map the columns in the file to the columns in the destination table. When importing table content from a CSV or Tab file, you need to specify the file format in detail as different programs can create these files differently. This means that if you simply need to export any file containy any SQL number of statements, you can use the вЂњImportвЂќ process to do it. When importing from an SQL file, Querious essentially just executes the SQL statements found in the file. Select the format appropriate for the given file. After selecting the file to import, another sheet will be displayed, and at the top are the file formats available to be imported from. To import data, select the File вћћ ImportвЂ¦ menu item. The settings for CSV and Tab importing can be tweaked to meet special requirements to enhance compatability with other programs. Querious can import databases and table content from CSV, Tab, and SQL.

Querious dictionary