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
[email protected]
--
For unsubscribe instructions e-mail to: [email protected]
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
