Simon,
I entered what you asaked and no, that file is in
the users\John directory
so I guess that the cmd sqlite3 DXCC is not shifting the focus to the
directory that the DXCC database is in
and i would need to be using some other set of commands to make that happen
Alan
On 25-Aug-16 16:45, Simon Slavin wrote:
On 25 Aug 2016, at 4:03am, Alan <zl...@clear.net.nz> wrote:
attempt to import a short test Excel table
of two columns with about 4 records in it, the main one I was trying to import
had the same trouble
with, it had over 300 records in it with two columns.
Issue this command:
sqlite3 DXCC.sqlite
then inside the SQLite shell tool do the following:
CREATE TABLE testTable (testColumn TEXT);
.once testoutput.txt
.schema
.quit
Do you find a new file called 'testoutput.txt' in the same folder as your
anr.csv file ?
Assuming that you /do/ get the file you expected ...
Open anr.csv using NOTEPAD.
Does the file look like comma-separated values to you ?
Is the top line a line of data (probably numbers) or does it have column names ?
You're importing the data in that file into a table.
Have you already defined the table in your SQLite database before you issue the
.import command or are you expecting SQLite to create the table for you ?
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