Export to CSV

its possible to export data as text file, if possible export as text file and open with Excel file and convert to CSV file.

Hi ukerandi,

Yes have tried it but date format is not right.

Thank you

1. Does the date column exist in the CSV file?

2. What is the format of the data in the date column?

If you export to CSV and load back into Excel immediately, is everything there?  If so, it's working correctly and maybe it just *looks* like something is missing (or maybe the app loading it is not properly interpreting things.  For example, Excel does not typically export blank columns at the end unless it has a reason to do so; therefore it may appear that data is missing.  For missing data between columns of other data, you'll get consecutive commas showing up to indicate missing data in a specific location.

And you indicated that "date format is not right"
What are you expecting it to be, and is Excel showing that in the cell?

Guys,

When I export same file from my PC or any other user PC then I get all 15 columns (all columns got data) but the PC I am having problem with come out only 9 Columns.

About format is not right when I export to text file then convert into excel.


Thank you

Are the regional settings for the problem PCs the same as the good PCs?

Yes...settings are same..even I have Reinstalled Office 2010 few times with SP1.

Is it possible that the columns are hidden, rather than missing?

please post the first 10 rows of the data (.CSV) and an example of the same data imported (incorrectly) into Excel (.xlsx).

Fixed after reset PC from factory setting.