[mojocafa]

Is anyone familiar with sqlite3. I have received a memory stick with info on it and don't know how to access the file.

Anyone any ideas?

[Small Plot Big Ideas]

Thanks for prompting my curiosity with this - I've not specifically used this in any of my coding but I have worked with many other SQL-based databases so it's been interesting (in a slightly geeky way) to investigate further   

There is a Windows command line program which could be used to query the data but you'd need to be familiar with SQL commands/syntax to use that.

Take a look at https://www.sqlite.org/cli.html

[benkt]

Something like SqliteBrowser should do the trick if your SQL skills are a bit rusty - it provides a GUI for browsing sqlite dbs.

https://github.com/sqlitebrowser/sqlitebrowser/

[mojocafa]

Cheers for above, the file I am trying to access has hmrc info on it, someone else had advised registering on line with hmrc then through their site I should be able to access info, does that make any sense to you guys

[benkt]

Makes some sort of sense to me - I used to use HMRC's windows software for doing PAYE etc. and I'm pretty sure that used sqlite as a db athough I thought it all moved to the web, either that or the accountant started doing it!? Perhaps I'm thinking of https://www.gov.uk/basic-paye-tools

[doganjo]

Why do you need a specific and unusual software to access HMRC info - it's all in plain script on the website.    Or am I missing something?
Yes you need to register with HMRC - then wait for them to send you a piece of paper with an access code - they are so security conscious that it's a bloody pain!  I waited 3 months for my self assessment code, and i've been waiting a  month for our fiddlers workshop one for gift aid.