https://bugs.documentfoundation.org/show_bug.cgi?id=140303
[email protected] changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |WORKSFORME
Status|NEW |RESOLVED
--- Comment #6 from [email protected] ---
Thank you Alex, you are right, it seems to work even with a SQL query directly
from the database, without detour over calc. I found this:
Create Text Table "Report_txt" AS (Select * FROM "Report") WITH NO DATA;
/* Link it to a text file "Report_txt.TXT" with \r\n newline delimiters and
without field labels: */
SET TABLE "Report_txt" SOURCE
"Report_txt.TXT;encoding=UTF-8;fs=\r\n;ignore_first=true";
INSERT INTO "Report_txt" (Select * From "Report" );
SET TABLE "Report_txt" SOURCE OFF; /* disconnect from underlying data source
*/
DROP TABLE "Report_txt" IF EXISTS; /* delete */
I try this and mark this bug as resolved. Regards
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
