Re: [libreoffice-users] Can one export from Calc a spreadsheet raw into a MySql database table raw?
On 04/13/2012 04:29 PM, Steve Edmonds wrote: On 2012-04-14 08:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? I don't know if someone else can help with loading straight from calc, but you could save as a CSV file and use the LOAD DATA command to load into MySQL. Just check the result is as intended. http://dev.mysql.com/doc/refman/5.1/en/load-data.html Steve An alternate athttp://dev.mysql.com/doc/refman/5.5/en/load-data.html -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can one export from Calc a spreadsheet raw into a MySql database table raw?
On 04/13/2012 04:06 PM, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? You can import Open Document Spreadsheet directly from phpMyAdmin to MySQL. cK -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Can one export from Calc a spreadsheet raw into a MySql database table raw?
On 2012-04-14 08:06, Csanyi Pal wrote: Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? I don't know if someone else can help with loading straight from calc, but you could save as a CSV file and use the LOAD DATA command to load into MySQL. Just check the result is as intended. http://dev.mysql.com/doc/refman/5.1/en/load-data.html Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Can one export from Calc a spreadsheet raw into a MySql database table raw?
Hi, I made in Calc a spreadsheet and now I want to export some raws into a mysql database table's raws. I have created already the database using command mysql to log into mysql server and have already the table in database with corresponding fields in table. Can I export somehow these data from Calc into database or must I manually fill every field in the table's records? I can connect to this database from LibreOffice, but don't know how could I easily tranship datas from Calc into table's fields? -- Regards from Pal -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted