I'm not big on either Excel or ODBC, so I can't help with the details, but...
There's an ODBC driver for SQLite you could install on your customer's system, and I'm pretty sure Excel can render data from an ODBC data source. So, if what you really want is to view query result data in Excel, it seems you could start here: http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc -Clark ----- Original Message ---- From: sqlfan <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, January 8, 2008 2:50:00 AM Subject: Re: [sqlite] free excel-like COLORFUL gui for sqlite 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] -----------------------------------------------------------------------------
