Hi,
I am trying do bulk load like I saw here http://www.monetdb.org/Documentation/Cookbooks/SQLrecipies/LoadingBulkData, but I am not having success when doing it.
I am trying to bulk load more than 60k registers using the following command:> mclient -d adventurework -s "COPY INTO FactInternetSales FROM STDIN USING DELIMITERS ',', '\n', '\"'" - < C:Users\dir\text.txt
After running this command I do not receive any error message but I cannot see the data in the database either.What am I missing here? Am I trying to this in the wrong way?
PS: I also tried with a smaller file but in the end I have the same result. I attached my partial data file in case of being necessary and the create of this table. And the system is Windows.
Thanks for your attention.
Best regards,
--
Raquel Ribeiro
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list