Hi, I have two questions here.
1. I exported some data from one of the database and export file are text file.
Then I tried to import to Excel, but I found all the data are in one column even though I tried to use all the setting. Then I tried to go back to my text file, but find all the data on the text file are all crowded on the left side. Only I can do now is to adjust one record into one column manually in text file and then import it to excel. Does any of the expert know how to fix it to save some time.
2. When I save the file in csv format, the zip code starting with 0 are automatically deleted after I saved the file. Any suggestions? Thanks!
Try exporting as a csv rather than a text file. What is the field type for the Zip Codes?
Life's more painless for the brainless.
It didn't work even if I export it in csv.
Regarding the data type of the zip code, I have tried text and some other format, but it still doesn't work after I have saved it in csv.
Why don't you just export it as an xls? Life's more painless for the brainless.
Have tried to use the Text To Column feature in Excel to expand the single column? It may not do it perfectly, but it might help. As far as the zip codes dropping the leading 0, you should be able to use this process to fix it:
Assuming your zip codes start in A1, use this formula to add a leading zero as needed:
=IF(LEN(A1)<>5,"0"&A1,A1)
Drag the formula down as far as required.
Once the cells are all 5 digits again, do an Edit...Paste Special...Values and format as desired.
I did some program from the original database and export the data. I am tired of saving the excel file to csv. Every time the data is OK, but after I save the file in csv and reopen the csv, all the data are hidden. Does anyone happen to know what causes this and how to fix it? Thanks!
