I would like to be able to initially populate a relational HSQLDB database using a CSV file. Specifically, I would use a file that looked like this:
LastName, FirstName, Unit, Position, MemberID, Status to populate a Members table containing LastName FirstName MemberID (other info) and a Unit table containing Unit MemberID Position Status (other info) I recognize that this will almost certainly require scripting. Could someone give me pointers on where to start? Alternatively, I am a fairly competent Perl scripter, so if it was possible to directly load up the database using a perl script to write the info, I would be up for that. Any ideas on what that would take (or whether this qualifies as a "here there be dragons" thing). Thanks for your help, Jon Dixon -- _______________________________________________ NEW! Lycos Dating Search. The only place to search multiple dating sites at once. http://datingsearch.lycos.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
