[libreoffice-users] Re: Can one export from Calc a spreadsheet raw into a MySql database table raw?

Am 13.04.2012 22: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?

Copy the cell range with or without column headers.
Select the table icon in the database window.
Paste.
Choose "Append data" and wether there are column headers.

Drag&Drop works as well.

You can also drag database table icons between database documents (which 
may also be connected to a Calc document)


--
For unsubscribe instructions e-mail to: users+help@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