Skip to content
agershun edited this page Dec 13, 2014 · 8 revisions

SELECT INTO

    alasql('SELECT * INTO AfrikanCountries FROM Countries WHERE Country = "Afrika"');
    alasql('SELECT * INTO TXT("cities.txt") FROM cities');

Data format conversion (from XLSX to CSV):

    alasql('SELECT * INTO CSV("parts.csv") FROM XLSX("parts.xlsx") WHERE Qty > 10');
Clone this wiki locally