Database viewer and exporting (1 Viewer)

[Lyfesaver74]

I was thinking that some sort of database viewer for the backend would be a good idea. What I was wanting to be able to do is look at my database in a spreadsheet format so I can set the order by fields. By clicking on the "Actors" column, it will reorder by that column alphabetically, effectively listing all entries without "actor" data, then move on to summaries, etc...etc...etc.

I have trying to research sqlite to xls conversions, but have failed so far. Any ideas?

 

[RoChess]

I was thinking that some sort of database viewer for the backend would be a good idea. What I was wanting to be able to do is look at my database in a spreadsheet format so I can set the order by fields. By clicking on the "Actors" column, it will reorder by that column alphabetically, effectively listing all entries without "actor" data, then move on to summaries, etc...etc...etc.

I have trying to research sqlite to xls conversions, but have failed so far. Any ideas?

Just download an SQLite tool, and learn SQL queries as per: SQL Tutorial

But most of the SQL tools have the column sorting method included where you just click on the column header and it will indeed 'sort' it ascending or decending depending on how many times you click the header.

Such as SQLite Expert Personal (Free Edition) @ SQLite Expert - A powerful administration tool for your SQLite databases

 

[Lyfesaver74]

Thx RoChess, i did not know about those tools. I am not a SQL pro by any means, but understand DBs well. I have not come across any tools that display DB data in a spreadsheet format, but I will try the tools you suggested. What I have come to find out in the past 24 hours is that my movingpictures DB is corrupt.... at the base level. Even tho MP is working, it is working on a borked database. So I am recreating it, then will try the tools u suggested.