I dare say someone will ask why you don't use Access 97 (or later) to display the file. It would be the easiest option, after all! If you don't have Access try OpenOffice, it's free.
If you really want to use Sqlite I'd load the file into Access (or OpenOffice), export it as comma or tab delimited text and start from there. You won't get any pretty colours or text formatting in Sqlite. And it may be that the file has all sorts of strange columnar formatting, formulae and labels that make it unsuitable for transfer to a plain ordinary database format, where all rows have an equal number of columns, and each column has the same type of data in it. Spreadsheets are designed for flexible display, whereas a database is inflexible (but that is often its strength - you know that column 5 will always be the price of your widget, and not a label or a formula). If the Access file has many pages, each page will have to be exported and turned into a separate table, with any necessary linking done through your Sqlite SELECT queries. Michael Hooker On 10/04/2008 20:57:03, John Grant ([EMAIL PROTECTED]) wrote: > Hello, > > I'm new to database programming. I'm trying to display information from > a file that is said to "use the Access 97 format". Can SQLite help me? > If so, where should begin? > > Thanks, > > > > John K. Grant > > Systems Technology, Inc. > 310-644-3887 (X 58) > [EMAIL PROTECTED] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
