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

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

User, date Message
Written by mr.riziq
3 years ago
Category: Import/Export
8 posts since Tue, 24 May 11
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
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
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.
Written by mr.riziq
3 years ago
8 posts since Tue, 24 May 11
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
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
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.