Thanks again for that Drew. As far as I can see, that has worked exactly as required.
Ed From: Drew <[email protected]> To: [email protected] Content-Type: text/plain; charset="UTF-8" Date: Tue, 05 Oct 2010 11:14:57 -0400 Message-ID: <1286291697.18890.18.ca...@sybil> Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: Re: [users] Exporting a database 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 ?
