lundi 31 août 2015

Unable to import a csv into a table in SQLite: no such table error

I have a wireshark dump in .csv format that I want to analyze. I tried importing the CSV file as described here. These are the commands I ran from the command line-

sqlite> create table network(no,time,source,dest,proto,info);
sqlite> .separator ",";
sqlite> .import E:\\Pavan\\_DataScience\\MP1\\network_data1\\challenge_network\\TestNetworkData.csv network;
Error: no such table: network;
sqlite> .tables
network
sqlite>

The .table command clearly shows that the network table is indeed present. I am not getting why the import command fails.

PS: I am running the sqlite3 executable downloaded from the official site on Windows.

Aucun commentaire:

Enregistrer un commentaire