Re: [sqlite] sqlite importing csv

many thanks again for the replies and sorry I was amiss in not stating that it was sqlite3 DXCC.db, I was using the .db suffix but to no avail, however the problem has been that I was not getting it into the right folder to enter the import command. Thanks Bill you hit it on the nose,

Re: [sqlite] sqlite importing csv

ght clicking on the folder, then select "Open command window here". This is an alternative to cd-ing to the folder from a default starting location. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Alan Sent: Thursda

Re: [sqlite] sqlite importing csv

nglists.sqlite.org> > Subject: Re: [sqlite] sqlite importing csv > > By the way I have a folder C:\jt65Logger that contains all the databases etc > to > do with the project. > > > ___ > sqlite-users mailing li

Re: [sqlite] sqlite importing csv

On 2016/08/25 9:35 AM, Alan wrote: 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

Re: [sqlite] sqlite importing csv

By the way I have a folder C:\jt65Logger that contains all the databases etc to do with the project. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

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

Re: [sqlite] sqlite importing csv

after clicking on the command it is in C:\users\john after typing sqlite3 DXCCit shows sqlite> if I then enter cd it shows ...> On 25-Aug-16 18:01, Simon Slavin wrote: On 25 Aug 2016, at 6:59am, Alan wrote: I right Clicked on start and selected the windows

Re: [sqlite] sqlite importing csv

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, 25 August, 2016 01:02 To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] sqlite importing csv On 25 Aug 2016, at 6:59am, Alan <zl...@clear.net.nz> wrote

Re: [sqlite] sqlite importing csv

On 25 Aug 2016, at 6:59am, Alan wrote: > I right Clicked on start and selected the windows cmd, and as I understand > it at the moment > > by typing sqlite3 DXCC then it should be sitting in the directory or folder > that the DXCC database is in I don't think this is

Re: [sqlite] sqlite importing csv

I have created a directory for the project I am working on, and the Database and the csv file both reside in that directory. I right Clicked on start and selected the windows cmd, and as I understand it at the moment by typing sqlite3 DXCC then it should be sitting in the directory or

Re: [sqlite] sqlite importing csv

On 25 Aug 2016, at 4:03am, Alan 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

Re: [sqlite] sqlite importing csv

On Aug 24, 2016 10:25 PM, "Alan" wrote: > > forgot to reply to one of the questions. > > I am using version 3.13.0.0 and it is 64 bit > > I am running Windows 10 Pro > > computer is intel I3 3.5Ghz with 8Gb RAM. > > As my friend has no problem loading the same csv file with

Re: [sqlite] sqlite importing csv

forgot to reply to one of the questions. I am using version 3.13.0.0 and it is 64 bit I am running Windows 10 Pro computer is intel I3 3.5Ghz with 8Gb RAM. As my friend has no problem loading the same csv file with his Windows7 computer I am guessing that it may be to do with running

Re: [sqlite] sqlite importing csv

HI Guys really appreciate all your replies.What I am doing at present is to 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. the test one has