> 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
