Export Data and Import to Excel

November 29, 2007 at 17:52:08
Specs: XP, 1GB

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!


See More: Export Data and Import to Excel

Report •


#1
November 30, 2007 at 07:25:53

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.


Report •

#2
November 30, 2007 at 09:20:14

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.


Report •

#3
November 30, 2007 at 11:45:46

Why don't you just export it as an xls?

Life's more painless for the brainless.


Report •

Related Solutions

#4
November 30, 2007 at 17:14:25

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.


Report •

#5
December 17, 2007 at 15:05:44

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!

Report •


Ask Question