Solved

Export to CSV

Posted on 2011-09-20
11
835 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:Vijaytyagi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 10

Expert Comment

by:ukerandi
ID: 36572743
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
 

Author Comment

by:Vijaytyagi
ID: 36572796
Hi ukerandi,

Yes have tried it but date format is not right.

Thank you
0
 
LVL 45

Expert Comment

by:aikimark
ID: 36573410
1. Does the date column exist in the CSV file?

2. What is the format of the data in the date column?
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
LVL 22

Expert Comment

by:rspahitz
ID: 36574509
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
 

Author Comment

by:Vijaytyagi
ID: 36579164
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
 
LVL 45

Expert Comment

by:aikimark
ID: 36579345
Are the regional settings for the problem PCs the same as the good PCs?
0
 

Author Comment

by:Vijaytyagi
ID: 36579465
Yes...settings are same..even I have Reinstalled Office 2010 few times with SP1.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 36579526
Is it possible that the columns are hidden, rather than missing?
0
 

Accepted Solution

by:
Vijaytyagi earned 0 total points
ID: 36579709
Thats what I thought but its not the case :-)

Thank you
0
 
LVL 45

Expert Comment

by:aikimark
ID: 36579801
please post the first 10 rows of the data (.CSV) and an example of the same data imported (incorrectly) into Excel (.xlsx).
0
 

Author Closing Comment

by:Vijaytyagi
ID: 36898951
Fixed after reset PC from factory setting.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question