distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

mr.riziq posted 3 years ago in Import/Export
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
ansgar posted 3 years ago
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.
mr.riziq posted 3 years ago
Alright, You are the Expert smile
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
ansgar posted 3 years ago
As said, you have to use Import > Import text file. Inserting files inserts just the whole contents of a file into one column.

Please login to leave a reply, or register at first.