How can i Export a table as excel sheet .xls file ?

Hi,
How can i Export a table as .xls file, then i need to insert a new data that about 10,000 rows , finally i need to import it back instead of my old table ?

Thanks

Rightclick any grid and click "Export grid rows".

For importing use the main menu "Import" > "Import text file".

As said, that includes quite some risk of data loss for NULL values or wrong/unsupported string encoding. You should definitely use some direct grid editor, not Excel. You are warned.

Alright, You are the Expert
I found that there's a fantastic option, it might be useful, The (Insert files into table..)..

How Could i insert the data column by column ?

I tried to input one column "frindly_url" as an example, but it keeps giving me an error said that (Sql Error(1048): Column "title" can't be NULL)..!!?

Do i need to input all of the columns once or what is the method, please?


Thanks

As said, you have to use Import > Import text file. Inserting files inserts just the whole contents of a file into one column.

Hi,

I know this is an old thread, but I have the same question 4 years later.

I have a large table I was thinking of editing via excel and then reuploading it.

Ansgar, you mention that a grid editor is a better option than Excel. Which grid editor do you recommend - I use a Mac is there anything specific for a Mac?

Hope you can help. Thanks

Dunxmax

Use HeidiSQL's data grid editor.

Ha,

Apologies.

I'll take a look into it.

Thanks

Dunxmax