Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I import data from a csv to SequelPro?

I have a small data file and I'd like to analyze it with SequelPro.

I have it connected to a MySQL server running on my computer.

When I try to import, the Import button is just greyed out.

like image 598
Sebastian Avatar asked Sep 22 '17 04:09

Sebastian


People also ask

How do you import data from a CSV?

On the Data menu, point to Get External Data, and then click either Edit Text Import or Data Range Properties. If you select Edit Text Import, select the file that you imported originally, and then make changes to the external data in the Text Import Wizard.

How do I import data into Sequel Pro?

To import an SQL dump file using the most recent version of Sequel Pro, connect to your MySQL host and select a database, then choose 'Import...' from the File menu.

How do I import a CSV file into Popsql?

After creating the sample CSV file and table, you can now easily execute the PostgreSQL Import CSV task via any of the following methods: Method 1: Perform PostgreSQL Import CSV Job using the COPY Command. Method 2: Perform PostgreSQL Import CSV Job using PgAdmin.


1 Answers

You need to create a table first. Only then will the import button become selectable.

like image 181
hyprstack Avatar answered Oct 23 '22 23:10

hyprstack