Importing data - hankinsoft/SQLPro GitHub Wiki

Import from CSV

First, right click on either a database node or the tables node, as shown here:

Next, you will be able to choose the CSV file you with to import. Pick a file. Some initial data will be loaded an processed, then you will be prompted to fill in some import data.

You may choose to either create a new table, or pick an existing table to import data from. If you choose to create a new table, the data will be inspected and default data types and nullability will be determined.

When generating a new table, the New column name and New column type fields may be modified by double clicking them.

Once you are ready to import, hit the import button and the process will begin. Depending on the amount of data, this may take some time.