Still not sure why you want to use SQLite here, but I think to get what you want you will have to code it yourself.
RBS > > Let me be more clear. There's very little data, and I want to help my > client > be able to expand his business, so the first step is automating what he's > been doing by hand. I can get the excel data into sqlite no problem -- > and > wish to do so in order to START doing automated stuff with the data -- but > would like to PRESENT (and only present) the data in the familiar > spreadsheet manner. > > This is a general problem: many people use excel as a database only > because > of how nice it looks once they add coloring, and because it's easier to, > say, have the three address fields as three columns, even though logically > it should be a separate table Addresses. So, I'd like to have the same > familiar input view without having the client worry about the details > (which > column is really what table, etc) and also to be able to color it as he > has > done to date. So, is there is a free gui frontend to sqlite that will do > it, or do I have to code one myself? > > Thanks! > > > > bartsmissaert wrote: >> >> If it is so good then why would you want to use >> SQLite? Holiday data can't be that much, so I would >> think Excel can cope with that fine. >> If you really want to move the data from Excel to >> SQLite then you will need a VB wrapper. >> >> RBS >> >>> >>> I have a client who's using a colorful excel sheet as a database. It's >>> colorful, well-structured, and a joy to use. He has no code working on >>> the >>> data though -- it's just used for holding data, like a ledger book! >>> >>> My question is how I can put his information into a sqlite database but >>> give >>> him a very similar interface -- the same, well-structured, colorful, >>> spreadsheet view? I don't want him to even have to worry about which >>> column >>> is actually in which table-- just have it look like an excel sheet. >>> >>> This is very basic and easy, and I'd hate to have to reinvent the wheel >>> coding it -- is there a free sqlite gui that can present such a >>> colorful >>> spreadsheet view? >>> >>> Thank you! >>> -- >>> View this message in context: >>> http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html >>> Sent from the SQLite mailing list archive at Nabble.com. >>> >>> >>> ----------------------------------------------------------------------------- >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> ----------------------------------------------------------------------------- >>> >>> >>> >> >> >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- >> >> >> > > -- > View this message in context: > http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686909.html > Sent from the SQLite mailing list archive at Nabble.com. > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
