How can i Export a table as excel sheet .xls file ?
| User, date | Message |
|---|---|
|
Written by mr.riziq
2 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
2 years ago 4023 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
2 years ago 8 posts since Tue, 24 May 11 |
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 |
|
Written by ansgar
2 years ago 4023 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. |