Hi Cristopher, Actually this will be updated throughout the software's cycle because we need to always add new airports and information relating to them. Yup! You got it running on Windows Vista. I will check out Active Python and see what I can't come up with then.
Scott -----Original Message----- From: Christopher Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 4:45 PM To: [email protected] Subject: RE: [sqlite] a newbie > From: [EMAIL PROTECTED] > To: [email protected] > Date: Thu, 3 Jan 2008 15:21:47 -0600 > Subject: [sqlite] a newbie > > Hey guys, > > My name is Scott Berry and I am totally blind and a newbie to Sqlite. I > have two questions concerning Sqlite. The questions I have is I have an > Excel file which will be going in to the database for an aircraft program > for the blind I am making. I want to turn this (Excel spreadsheet) in to a > .CVS file comma delimited or tab delimited. I don't care which. I am using > Sqlite Admin from Sqlite.org to do my databases since I am not too > comfortable with the syntax yet. However, two questions come to mind: > > 1. Which of the delimited files .cvs with commas or tabbed would be best to > use. Depends on if you have either commas or tab characters within your data. Commas and tabs are both ASCII characters. > 2. I need to put my info in by state and airport is it wiser to make a > table for each state? I will be using this with in a Basic 4 PPC program. If this is your first outing, I would go with something simpler. If the data support it, you could simply keep things in the original Excel arrangement. > Any help would be very much appreciated. If you have Excel files implies you're running on a Windows machine? It might be too much to try at once, but you could consider installing ActivePython, http://activestate.com/Products/activepython/ which would then let you use ActiveX data objects to pull directly from the .xls file, and then populate the sqlite file. This would be faster than writing everything out to the hard drive. However, if the data migration is a one-time event, ignore what I have just said, as it is not worth the complexity. > Scott > Cheers, Christopher L. Smith Have you pondered the meaning of life today? _________________________________________________________________ Share life as it happens with the new Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_122007 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.13/1207 - Release Date: 1/2/2008 11:29 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.13/1207 - Release Date: 1/2/2008 11:29 AM ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
