I learn how we could edit MySQL data using Microsoft Excel..
The way to be done as follows:
1. Export the data as "CSV for Excel".
2. Edit the data as you like but:
i) Makes sure if there is column data with "9999999999999" makes sure that the format cell is "TEXT".
3. Save as your file excel as "CSV (MS-DOS)".
4. Open that csv files and makes sure your data is correct.
i) Usually when number more tha "9999999999" will become "9999990000".
5. Before import to sql database....
i-create a New Table and create the same data structure as the old one.
6. Export it.
7. If there is error: When create new table just use "var char" for all and change it back later.
8. That's it.
Try it and gud luck... Any question? don't to ask because I dunt think i know the answer as I'm not expert in SQL...
No comments:
Post a Comment