On Tue, 2010-10-05 at 15:52 +0100, Ed Warne wrote: > Thanks Drew > > That seems useful. I'm assuming the * is meant to be after the SELECT, rather > than before the FROM? > > Is a csv just text? > > Do I need to CREATE and SET TABLE in SQL first, as I can't see a way to do it > with design view or Wizard? I'm struggling with this, as it's the first one > I've tried to do in SQL. > > Essentially I want 9 fields all text except for one date I need a combined > primary key covering 3 of these (possibly 4 for correct sorting), which may > need an extra field. This is required for forcing unique records, as > individual fields may be duplicated. > > I'm also guessing I may need "ALL QUOTED" option > > Roughly what would the full process look like? > > Thanks again, > > Ed >
Hi Ed, I think this link will help: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=26843&p=122081 Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
