CVS file only inserts commas for 15 lines of spread

Hi,

I hava an user in Europe that is following the exact steps I am to
covert a file to CSV format.  When we open her file in word pad, only
the first 15 lines of data have comms delimted.  It happens every time
regardless of how much data is in our spread.

Any ideas on how to correct this?

Thanks much!
S
0
4/15/2009 2:36:41 PM
excel 39879 articles. 2 followers. Follow

1 Replies
364 Views

Similar Articles

[PageSpeed] 0

I've never seen anything like this.

If they reopen the .csv file in Excel, does it look ok?

If they open the file in NotePad (not wordpad), does it look ok?

My silly guess:

I'm wondering if there is any special character in the data that is being used
as an end of file marker.



SherryBerry wrote:
> 
> Hi,
> 
> I hava an user in Europe that is following the exact steps I am to
> covert a file to CSV format.  When we open her file in word pad, only
> the first 15 lines of data have comms delimted.  It happens every time
> regardless of how much data is in our spread.
> 
> Any ideas on how to correct this?
> 
> Thanks much!
> S

-- 

Dave Peterson
0
petersod (12005)
4/15/2009 3:26:45 PM
Reply:

Similar Artilces:

Line Deleting Problems
When I draw a line and come back to it later to delete it, Publisher 2002 will not recognize the line when the cursor is on top of it--anywhere. Therefore, I am unable to edit the line. HELP! Is this a software problem? Linda After managing to set up OE-QuoteFix on his new PC, Ed reads a message from Linda <Linda2NPBC@aol.com>... > When I draw a line and come back to it later to delete > it, Publisher 2002 will not recognize the line when the > cursor is on top of it--anywhere. Therefore, I am unable > to edit the line. Do you have text boxes or other objects coveri...

Can data files for mailmerge be updated?
I have a 4 year old 3.5 disc with addresses that I update each year. Last year I updated using Windows 98, with Office maybe Publisher 2000. Now I am unable to access the info with my Windows XP and Publisher 2003. Is there a way to get to this data, edit it, and make labels in 2005? Thanks Robin from Alaska Copy the list to "My Data" folder in "My Documents." Is it a Publisher list? If it is a .mdb file, Publisher should read it. I think your problem is mainly the floppy disk. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews...

Moving .pst MS Outlook files from local PC to home NAS server
I just installed a HP Mediasmart NAS home server at my home. Our storage needs are just getting to vast for each PC to store all our digital assets. Anyhow, I noticed that on my personal PC one of the largest files I have is my Microsoft Outlook 2007 .pst files. It's where MS Outlook stores all my archived emails. I'd like to learn how to MOVE this file to my HOME SERVER and POINT MS Outlook to archive all my .pst files at this location thus freeing up my local PC from these HUGE files. Does anyone know how to do this? "bob sacco" <bobsacco@discussion...

Windows File Sharing On Home Network
I have a Dell Deminsion 3000 and a Dell Inspiron 6400 both running XP home, 2002, with SVP 3. In the past I have been able to share files between the two with no problems. I have tired all of the troubleshooting suggestions from microsoft and other online forums. I have enabled fire sharing and still when I try to access the files from one computer to another I get the same error message " file not accessible. You may not have permission to use this network resource. Contact the admenistrator of this server to find out if you have access permissons. Any suggestions would gre...

Reading from test.csv file
I have the folowing test.csv file: ENTITY","INTEREST ","AMOUNT " "CSD01"," 1.4567","3,456.1234" "CSD01","456.1234"," 1.4567 " When I open it with excel, the number 3,456.1234 becomes 3,456.12 The number 456.1234 is the same in excel. I do not want to change anything on the excel setting, ie, if one wants to open my test.csv file using his excel, he will not need to do any setting changes, and he still be able to see the entire number. Is there a way to solve it? Thanks, Joe Looks like all he...

search for publisher file
is it possible to find a publisher file when doing a windows search. Yes. I assume you're having difficulties tho. -- JoAnn Paules Microsoft MVP - Publisher How to ask a question http://support.microsoft.com/kb/555375 "Pauline" <Pauline@discussions.microsoft.com> wrote in message news:F75DB370-0A6A-4791-A6EC-F61B7C24992D@microsoft.com... > is it possible to find a publisher file when doing a windows search. Pauline wrote: > is it possible to find a publisher file when doing a windows search. If you search for *.pub you will find all Publisher files. If y...

Exchange 2003 log files #3
Is it safe to delete the OLD log files in the Exchsrvr\srvrname.log folder and Exchsrvr\mdbdata folder? On Mon, 12 Sep 2005 09:44:02 -0700, "Paula" <Paula@discussions.microsoft.com> wrote: >Is it safe to delete the OLD log files in the Exchsrvr\srvrname.log folder >and Exchsrvr\mdbdata folder? > The Servername.log dir are the tracking logs, they should be deleted automatically according to the General tab of the server properties in ESM. Do not delete the log files in the mdbdata directory. Run an online full exchange aware backup to purge those. I use CA...

Validating XML file against an XSD schema
I have an XML file i'd like to validate against an XSD schema. I'm creating the XML on the fly in an ASP.NET page and need to validate it aginst the schema to ensure its well formed. How do i do this? Thanks in advance... Simon Ames Hi simon, Why not searching the msdn? i searched for "xml" "validating" "xsd" and found some pages where to find example code using the XmlValidatingReader e.g. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemXmlXmlValidatingReaderClassctorTopic1.asp http://msdn.microsoft.com/li...

Import CSV file into Project with Hard Returns
How do I import hard returns into MS Project? I have tried \r\n but that shows up as actual text instead of a line return within the notes column. I assume you are importing to the Notes field? If so, it should read everything between the double quotes denoting the string. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "chazparks" <chazparks@discussions.microsoft.com> wrote in message news:54511FC0-AC16-4A11-B8F8-858205CB1D55@microsoft.com... > How do I import hard returns into M...

import .pst file into entourage 2008 no access to pc
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel my pc just broke I have my outlook 2007 file saved in a .pst file, I don't have access to a pc, what I can do to import in entourage? <br> It seems that for mac office the compatibility is essential but not for all!!! On 4/7/10 6:53 PM, ladyelena@officeformac.com wrote: > just broke I have my outlook 2007 file saved in a .pst file, I don't > have access to a pc, what I can do to import in entourage? There are some third party option that can help with that. Check out the options on...

undocumented alternative to module CountOfLines, Lines
For Access 97 and Access 2000, what is the method to extract text for a form at the project level? This is an alternative to using Lines and CountOfLines on the module. It may be undocumented, I don't remember. Thanks The answer is "SaveAsText" with compliment "LoadAsText". Thanks The answer is "SaveAsText" with compliment "LoadAsText". Thanks "dgm" <work-del@del-subjectivist.org> wrote in message news:4CB8DFB2-35D7-43DD-8D69-4AD928CC5A82@microsoft.com... > The answer is "SaveAsText" with compliment "L...

minor inconvenience opening file
Using Word 2002 and Word 2007 in W 7. If a file is minimized in Word, and I happen to double click on a different doc file elsewhere, Word will open the new file but will also restore the minimized file forcing me to later re-minimize it. Can Word be made to open the new Word document without also restoring the previously minimized doc? Thanks, Jeff <Jeff@nospam.fake> wrote in message news:u3zhlnk5KHA.980@TK2MSFTNGP04.phx.gbl... > Using Word 2002 and Word 2007 in W 7. > If a file is minimized in Word, and I happen to double click on a > different doc file ...

restoring addresses and sent files
Hi, I can not access my old sent files or address book. Before I went through an XP restore, I saved all .pst files (all eight)and copied them successfully back to the Documents and Settings/owner/local settings/application data/microsoft/outlook directory. Here are the file names: 1. archive - 48 KB 2. mailbox - 32 KB 3. Outlook - 106 MB 4. Outlook1 - 103 MB 5. Outlook2 - 109 MB 6. Outlook3 - 32 KB 7. Ted_Home - 69 KB 8. Outlookold - 900 KB When I go to "Tools" and "E-mail accounts" and then click on "Directory and "view or change existing directories ...

Tax line on receipt
The tax line does not show up on the receipts that my client produces. Is this an XML coding issue or is it merely a flag that needs to be set within the product (and where do I go to set the flag)? The question is: did the customer assign a tax schedule to the products? The XML code simply changes whether or not it shows the sales tax percentage. Each item has a tax code established in item properties under item tax. This category is set up under database/ item taxes. Then in configuration/sales tax/ select assign tax schedule. -- Elizabeth M. "SteveY" <SteveY@discussion...

Importind data from several files
Hi, I need to import data from several files into a single worksheet every month. I wish I could do this in the most automatic way possible (I didn't want to repeat the import process for each file). Is this possible? Thanks Look into the Data, Consolidate feature. -- David Hager Excel MVP "Jo" <joana.fernandes@aceplus.pt> wrote in message news:2da2601c394d2$036f88b0$a601280a@phx.gbl... > Hi, > > I need to import data from several files into a single > worksheet every month. I wish I could do this in the most > automatic way possible (I didn't w...

Outlook corrupted files
Before reformatting my hard drive my Outlook 2002 (PST) file was saved as 10 separate Outlook Express (DBX) files. This wasn't my idea, but I believe it was done because the Outlook PST file was very large and wouldn't fit on one CD. Now they don't read correctly with either Outlook or Outlook Express but the data appears to be in the files. The inbox.dbx for example is 99 mg but OE reads only some old files over 2 years ago. Any idea how I can get these back into Outlook? I have tried exporting from Outlook Express. Is there a program to analyze and correct the file...

Opening separate files in excel...
When I want to open multiple files (by using the shift/ctrl key and selecting the files), I cannot get them to open in separate windows, they all open in one window and I have to go to Windows then select my file...Any suggestions?? Thanks!! Greg If you are using Excel 2000 or later, try: Tools | Options Make sure you are looking at the View Tab. Over near the right edge towards the top, you'll see a check boc for Windows in Taskbar. Make sure it is checked. If you are using Windows XP, you may have to Right-Click on your System Clock and choose Properties and turn off Group Simila...

How to draw line between to boxes
I am very new to Visio. I am trying to draw a flow chart. I have drawn the boxes and now I want to connect them by lines. There is an "Arrow" tab in left side pane for shpaes but it seams that it is something different. Where is the draw line command? -- Rasoul Khoshravan Azar Civil Engineer Osaka, Japan On Mon, 27 Mar 2006 16:37:01 -0800, Khoshravan <khoshravan@discussions.microsoft.com> wrote: >I am very new to Visio. I am trying to draw a flow chart. I have drawn the >boxes and now I want to connect them by lines. There is an "Arrow" tab in >left s...

Vertical Line on a 2Y axes chart
How can I have a vertical line extended all the way in a line chart that have 2 Y axes? I have been using the horizontal/vertical line techniques without any issue until now, when my current chart carry values in KGs in the primary Y axis, and the same values in Lbs in the secondary axis. If I check out the secondary axis, the line will extend all the way, but I will lose my Lbs values. If I leave it checked, the line will cut short half way! Any trick to by pass this? Thanks. -- when u change the way u look @ things, the things u look at change. ...

Replication with Double-Take for SQL Dynamics DB's & Dynamics file
Hello, I am using Dynamics 7.5 and am looking to create a fail-over secondary SQL Server and replicate all of the Dynamics databases and files to this backup server using the software Double-Take. If anyone has any experience with the Double-Take software and Dynamics, please give me your comments and/or any problems that I should look out for. Thank you in advance for your comments. Elmo :o) DoubleTake is fine for system level failover, but it does no application level monitoring. You should look into LifeKeeper from SteelEye Technology for this. ...

Comma is not visible in Excel
Ok, this one is weird. I have a user with Office XP SP2, full install of Excel. When he types in 500000 for instance, no comma appears. Great, I says to him, I says "That's just a formatting issue." So, I go to Formatting > Cells and go to the Number category. Hmm..."Use the 1000 seperator ( )" option is already clicked. Check this out though, there is no comma in the text description, just like I typed it above. No comma. It's like the comma image ain't there, it's been totally blown away. Any suggestions? Hi check the settings under start ...

Re-using Contacts/PAB file
A user had to have Windows XP re-installed. Outlook 2003, POP3 email. I saved the PST file and the PAB file. - Re-installed Windows. - Setup Outlook, and imported the old PST. Set the old PST as the default file, and removed the mailbox/PST that was created when I initially setup Outlook. - Found instructions on the net on importing the PAB file for her Contacts. Everything seem to go ok, it appeared to import, gave the status bar going across the screen, but when it was done, no Contacts. I thought maybe the profile was corrupt. Deleted the profile, created a new ...

How to reduce file size to email without losing transitions?
I have a 29Mb ppt file that I would like to email without losing my sound, transitions or animations. Any suggestions? "PMarko" <PMarko@discussions.microsoft.com> wrote in message news:F4C141EE-8ADA-42CB-A1F0-88178D52573C@microsoft.com... >I have a 29Mb ppt file that I would like to email without losing my sound, > transitions or animations. Any suggestions? Transitions and animations won't contribute much to the file size. Sound, assuming it's an embedded WAV, can. (Other sound file types can't be embedded, so those don't contribute to file...

Combo Chart of stacked columns and line
Hello, is there a custom chart template that will show data as a combination of stacked columns and line in the same chart. I have data from two different areas of the company that I would like to put in the stacked columns (so the data shows individually but also a total for both areas together) and I have a goal for this kind of data that I would like to show as a line graph. Any suggestions, solutions are greatly appreciated. TIA. BR, Antje Crawford Plot all the data as a stacked column. Then, on the chart select the plotted series that you want as a line chart. With it selected, s...

VS2010 RC hogs VS2008 .sln files
In the past, clicking on an .SNL file generally spawned the version of VS that created it. And r-clicking would bring up several options, including "Visual Studio Version Selector", which essentiall did the same as above. After installing VS2010 RC on a machine that already had VS2008 Ultimate loaded, the VS Version Selector always opens VS2010, despite the original files having been built with VS2008. And simply clicking on one of the .SLN files (again, from VS2008) always brings up VS2010. There is no context menu (R-Click) for VS2008, even after specifically browsing t...