Various notes -At the prompt, running "sqlite3 DXCC" is starting the sqlite3 program, and telling it to open the file named "DXCC" as its database. If it's not given a full path then it opens it in the directory the command prompt is in when you run it. If the file you give it doesn't exist, then SQLite will create it after the first command that would require data to be written. So in whatever folder your command prompt opens up to there's probably a new file there called "DXCC".
-Having file extensions off is a cause of many headaches. (Long running major pet peeve of mine that MS made it default to hidden) When you type "sqlite3 DXCC" you're telling it to use the file "DXCC". Specifically, you're <not> telling it to use "DXCC.db" or "DXCC.sqlite" or "DXCC.something". You need to give it the exact file name. So if you have an existing file in there called "DXCC.db" where Windows "recognizes" the file type and hides it in Windows Explorer, and you type "sqlite3 DXCC" then it's not going to open the .db file, it'll make a new extensionless "DXCC" file. So, however you get to "Folder Options" in Windows 10, go there, then to the View tab, then make sure "Hide extensions for known file types" is turned off. -If you have Windows Explorer open you can open a new command prompt right to a specific folder by holding shift and right 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: Thursday, August 25, 2016 1:59 AM To: SQLite mailing list Subject: 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 folder that the DXCC database is in so should accept the sqlite command to import the csv file that is also sitting in that directory. I also tried it with the Admin cmd. On 25-Aug-16 16:38, Scott Robison wrote: > On Aug 24, 2016 10:25 PM, "Alan" <zl...@clear.net.nz> 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 his Windows7 > computer >> I am guessing that it may be to do with running Windows 10. > What directory are you in? Are you using an elevated command prompt? > _______________________________________________ > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
