Solved

Export to CSV

Posted on 2011-09-20
11
823 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
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Excel Multi Sheet Formula 13 37
Expanding and filling year gaps in multiple listings 6 28
Filtering - Visible Rows 22 28
Help with Excel 18 33
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

821 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