Export to CSV

Hi Experts,

I am facing problem with export to csv on XP pro sp3 machine.
I am exporting data from Sage MMS 200 v7.00.0043 to Excel 2010 as CSV (comma delimited file)
When I export and press save as to CSV it export the data but not showing all the column.

Row data is fine.

Exporting same file from different machine is perfectly fine.

So far I have
Reinstalled Office 2010,
Installed Office 2010 SP1,
Reinstalled Sage 200 MMS and
Installed all OS and other office updates.

But no joy!!!

Please help
VijaytyagiAsked:
Who is Participating?
 
VijaytyagiConnect With a Mentor Author Commented:
Thats what I thought but its not the case :-)

Thank you
0
 
ukerandiCommented:
its possible to export data as text file, if possible export as text file and open with Excel file and convert to CSV file.
0
 
VijaytyagiAuthor Commented:
Hi ukerandi,

Yes have tried it but date format is not right.

Thank you
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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

2. What is the format of the data in the date column?
0
 
rspahitzCommented:
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?
0
 
VijaytyagiAuthor Commented:
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
0
 
aikimarkCommented:
Are the regional settings for the problem PCs the same as the good PCs?
0
 
VijaytyagiAuthor Commented:
Yes...settings are same..even I have Reinstalled Office 2010 few times with SP1.
0
 
aikimarkCommented:
Is it possible that the columns are hidden, rather than missing?
0
 
aikimarkCommented:
please post the first 10 rows of the data (.CSV) and an example of the same data imported (incorrectly) into Excel (.xlsx).
0
 
VijaytyagiAuthor Commented:
Fixed after reset PC from factory setting.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.