Hi Simon,
firstly both the database and the csv files are in ther same folder.
I have gone into Windows cmd
typed sqlite3 DXCC(database)
.mode csv
.separator ,
.import anr.csv DXE(DXCC table)
I have also tried putting in the full path to the csv file and
unfortunately
the same result.
Alan
On 25-Aug-16 10:12, Simon Slavin wrote:
On 24 Aug 2016, at 11:04pm, Alan <zl...@clear.net.nz> wrote:
Firstly I am very new to sqlite, but I have a problem when trying to
import a .csv file into a database, getting "cannot open (file).csv"
I am using Windows10 and wondering if anyone else has had this problem.
The program is probably looking at the wrong folder/directory. Make sure you
understand where the program thinks the file is.
What program are you using to open the file ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
