Hello All, i'm new to maxdb and databases in general, and seem to have a problem with the loader.
as a test, i'm trying to load a very simple and small (3 lines) table that i have exported from access as csv. i created the database and table in maxdb, but when i run the loader the following error happens: loadercli -u DBA,dba -d crap1 -b c:\maxdb\tests\imp.txt where imp.txt is: DATALOAD TABLE dba.contacts contactid 1 surename 2 INFILE 'C:\maxdb\tests\contacts.csv' SEPARATOR ';' and contects.csv is: "1";"Smith" "2";"Robinson" "3";"Cage" the paths i verified that are all correct. the error i get is: C:\maxdb\programs\bin>loadercli -u DBA,dba -d crap1 -b c:\maxdb\tests\imp.txt Loader Server Protocol File: 'c:\maxdb\data\wrk\loader.prt' User DBA connected to database CRAP1 on local host. DATALOAD TABLE dba.contacts contactid 1 surename 2 INFILE 'C:\maxdb\tests\contacts.csv' SEPARATOR ';' Error during execution -->-25502 Error opening file '1': wrong file or device name. Defined maximum number of errors (1) reached 1 error(s) during execution of command file 'c:\maxdb\tests\imp.txt'. ---> See log file(s) for more information. Some error(s) occurred running command. ---> See log file(s) for more information. Any ideas on what i'm doing wrong? i have been reading past posts in the list but can't find why it doesnt load. thank you for your help __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
