On 05/26/2012 03:04 PM, NoOp wrote: ... >> I'll give your database a try this weekend & also try to find my ...
SQlite database created by: 1. Opening the archive .txt file in Calc & then saving as a .csv. Note: I modified the first header slightly from 'Timestamp' to 'Date Time' so that I'd have headers for both columns. 2. Open SQLite Manger & imported the .csv. Saved as an SQLite file. 3. Registered the new SQLite3 file using ODBConfig. 4. Opened LO 3.5 Base (Database from the menu), selected 'Connect to an existing database', choose ODBC, and select Weather2. Table shows all data from the archive file. Files are here if anyone cares to view/use. http://www.2shared.com/file/k8C-0SXm/Weather.html (Weather.odb) http://www.2shared.com/file/Fiddx6IL/weatherNoOp.html (SQLite file) http://www.2shared.com/file/1pj44lW9/weather.html weather.csv http://www.2shared.com/file/T9pvKz3y/weather.html weather.ods -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
