On Monday 29 March 2004 09:14 am, Dembskey, E. (Evan) wrote: > Hi again, > > Is there a quick way to import a text file into a sqlite db? I have 110 > records, and would naturally prefer not to manually enter them. If there is > a way to get the field names from the same file, so much the better... > > Data example: > > ID,Messier,Name,Type,Constellation,NGC,Magnitude,Size,RA,Dec,Season > 1,M001,Crab Nebula,Supernova remnant,Taurus,1952,8.4,5h 34.5m,22 01,Winter >
Look at the 'COPY' keyword. It will do the import , though you have to define the table yourself first. -- My GPG public key is at http://ronware.org/ fingerprint: 4E91 06E9 2020 114C 8BCD 55B2 0816 60AF 2B3D 4C51 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]