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
