Re: [libreoffice-users] Selecting records in base to a CSV

2011-12-09 Thread Jay Lozier
On 12/09/2011 10:38 PM, Scott Jones wrote: I am trying to select records in Base to a CSV. I have tried this statement and it works: SELECT * INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV FROM `License Survey Response Code Table (Public)`; But that is all records. I want a s

[libreoffice-users] Selecting records in base to a CSV

2011-12-09 Thread Scott Jones
I am trying to select records in Base to a CSV. I have tried this statement and it works: SELECT * INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV FROM `License Survey Response Code Table (Public)`; But that is all records. I want a subset using a LIKE statement. I've tried: S