Hi Aladdin, > SET TABLE "MyTable" SOURCE "test.csv" > > but I get this error : > Table not found in statement [SET TABLE "MyTable"] > > I've the csv and odb in the same directory. > > Any tips ?
You first need to create the table with a CREATE TEXT TABLE statement. SET TABLE SOURCE is the second step, which "connects" the table definition with the actual file. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
