I need to convert an excel file into csv file to import into the database. However, I cannot do with Vietnamese file as the font is error. Could anyone show me how to do so?
How convert excel into csv file with Vietnamese support?
1 posts
• Page 1 of 1
- MS WORD
- sharepoint
- Windows XP
- programming
- Win32 Programming
- MS SQL SERVER
- Windows XP
- Visual Studio .Net
- Microsoft Project
- c
Jump to:
- 1. How to savage a file that crashes? "Microsoft encounter a prob
Thanks bob, unfortunately the recovered file convert everything to text......all the formula are gone! "Bob I" wrote: > If you reopening the "crashed" workbook, Excel will offer to recover it. > Prevent it? Watch what you link to, alot of those "links" will trip > additional links to other scripts and that is where your problem likely is. > > GOH wrote: > > > I often encounter the problem in opening some of my big excel file - it juz > > crashes with a message "microsoft excel encounter a problem....". > > > > I suspect one of the problem is that my excel file has several links to > > external sources, including bloomberg links. > > > > How can i prevent this from happening? For those file that already have > > problem, is there any way to recover? > > > > - 2. Blank Cell Reference, without if statement
I have a worksheet which has some blank cells on it, and other cells with zeros. I am trying to reference it in another worksheet, formatted as a number with one decimal place. When I reference the blank cell, it comes across as zero. Here is a case example: Sheet 1, Column A, rows 1-5 2.3 <--Blank cell 1.5 0 3 When referenced on sheet 2: =Sheet1!A1 =Sheet1!A2 =Sheet1!A3 =Sheet1!A4 =Sheet1!A5 Comes across as: 2.3 0.0 <--Blank on Sheet 1 1.5 0.0 3.0 Is there any sort of formatting that I can do to the cell range on sheet 2 that will reflect the blank cell WITHOUT using an If statement. thanks, sean - 3. Need Formula - If blank cells
I need a formula to return true, based on cells in column b being blank. So if A1 is not blank, B1 is blank, and C1 is not blank return true. - 4. Is it possible
Ok, here is what I want to do. I have asked this question a couple o different ways and no one has given me any responses: I have a list (currently 45 entries) of companies who have entere complaint this year. I have created a pivot table to give me a coun of unique companies and how many times they have entered complaints. From this list and count, i want to create a chart that gives m company name on the x axis, the # of complaints for each company on th y axis, and the cum% on the secondary y axis. I need to be able to sor the data from low to high or high to low. My pivot table gives me a count of complaints for each company and th corresponding % of total. I can not figure out how to get the table t product the Cum% so that I can plot this on the above chart. The favor of reply would be greatly appreciate
Next
How convert excel into csv file with Vietnamese support?
by VHVuZy5OZ3V5ZW5EYW5o » Sat, 22 Mar 2008 12:22:00 GMT
Similar Threads:
1.Converting Large XML Files into CSV Files for Excel
Hi: I have a large XML file (a few hundered MB in size) that I need to import into Excel and save as a .csv file. Smaller files (< 5 MB) work fine, but as you approach this limit, you have to break the original XML file into smaller files, and work on them on at a time. For my current XML file, this would be broken down into easily > 50 sub XML files. The problems are file size, memory size, and Excel limits. Do you know of any way that this can be done other than the "manual grunt method" that I described about ? Any way of automating a script ? I am not real familar with Excel or any scripting language like awk, sed, or Perl, so your detailed feedback would be deeplyappreciated. Thank you...!!! DaleB Large XML file --> many small XML files --> many small .csv files. (CSV = comma separated values).
2.Converting Large XML Files into CSV File via Excel
Hi: I have a large XML file (a few hundered MB in size) that I need to import into Excel and save as a .csv file. Smaller files (< 5 MB) work fine, but as you approach this limit, you have to break the original XML file into smaller files, and work on them on at a time. For my current XML file, this would be broken down into easily > 50 sub XML files. The problems are file size, memory size, and Excel limits. Do you know of any way that this can be done other than the "manual grunt method" that I described about ? Any way of automating a script ? I am not real familar with Excel or any scripting language like awk, sed, or Perl, so your detailed feedback would be deeplyappreciated. Thank you...!!! Update: So far, I have been able to import an XMLfile ~36 MB in size into Excel. It just takes time (how long ? I do not know: I let it run overnight). WARNING: If you try to get a feel how things are going, a dialog box will state that the application is not responding,...but...if you look at the processes (via Ctrl-Alt-Del) you will see that Excel is still crunching on the amount of memory that it is using. DaleB Large XML file --> many small XML files --> many small .csv files. (CSV = comma separated values).
3.Convert one .csv file to multiple excel files
Hi, I have a csv file which has a number of datasets (for several years) , each yearly datasets are separated by a blank row. Can anyone please suggest an easy way to convert this dataset to an excel file for each individual year? thanks in advance Nagendra
4.Convert Regular Excel file into csv file
I have a regular spreadsheet that is in column format. I want to collapse the data into a csv sheet with all column collapsed into column A separated by commas. Is there any way that excel can do this? I tried to save as csv but it still displayed as columns. please help. Thank you.
5.Converting a CSV file to an Excel file
When I export a file from a website to an Excel file (on a Windows 2000 platform), it shows up in Excel as a standard Excel spreadsheet (I am using Office 2000). However, when I export the same file on a Vista platform, it shows up in Excel as a comma-delimited file. How do I convert a CSV file into an Excel spreadsheet? Thanks in advance for any thoughts. Gordon Biggar Houston, Texas
6. csv file convert to excel file
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 21 guest