<<< Back - Next >>>

Import data into table

Let's create a database table from an existing csv file.

1. Create a table with a field for each column in the csv file that we want to import

    CREATE TABLE nypl_items (
        id INTEGER PRIMARY KEY,
        title VARCHAR,
        contributor VARCHAR,
        year VARCHAR,
        language VARCHAR,
        description VARCHAR,
        note VARCHAR,
        subject VARCHAR,
        resource VARCHAR,
        genre VARCHAR,
        publisher VARCHAR,
        place VARCHAR,
        url VARCHAR
    );

1. Double click on the table "nypl_items" in the databases window and click on the import icon

1. Follow import instructions

<<< Back - Next >>>