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 subset using a LIKE statement. I've tried:
SELECT * FROM "License Survey Response Code Table (Public)"
WHERE "Survey Response Code" LIKE '04%')
INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV;
No Luck. Is my syntax wrong?
The normal syntax is
SELECT selectlist
INTO file or more often a table
FROM database
WHERE selection criteria
--
Jay Lozier
jsloz...@gmail.com
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted