How can I export txt(UTF-8 characterset) from Excel?

  • Thread starter Thread starter HOONHEE
  • Start date Start date
H

HOONHEE

Hi!
First. I'm sorry. I'm not used to English. ^^;
i'm using VBA in Excel(Office 2003).
I used "SaveAs" Method for coversion Excel to Text File with VBA...( For
uploading Oracle DB with Other Program)
But.
When Execel convert to Text File, Chiness words cracked during converting.
One man said me.
"When You convert excel to Text file.. change characterset 'UTF-8'!!"

I find SaveAs Option "xlUnicodeText" FileFormat.
I can't find Option about "UTF-8" fileformat.

How can I convert Excel to txt file with UTF-8 encoding...

If You know that. Advise me ^^;

Thanks you...
 
hi,
may be the problem occure while your windows doesnt support with asian
language / Chineese
Try to setup language option from control panel
 
Thank for your reply..

Hmmm...

Chiness use my excel program with their computer in China.

When they clik "Create File" button, VBA process do converting.
Chiness upload the result text file to Web System.

When I query DB. All Chiness cracked.
Oracel DB NLS = UTF-8

Can my VBA coding convert excel to text with "UTF-8" characterset?
 
Hi,

try to use this:

ActiveWorkbook.SaveAs Filename:= _
"C:\china.txt", FileFormat:=xlUnicodeText , CreateBackup:=False

xlUnicodeText --> is most important
 
That code below doesn't work unfortunately. However, if you want to use a macro (which I did) then this does:

http://www.ozgrid.com/forum/showthread.php?t=154957&p=560424#post560424

This will save your file as UTF8 format, within Excel 2007.


Halim said:
Hi,

try to use this:

ActiveWorkbook.SaveAs Filename:= _
"C:\china.txt", FileFormat:=xlUnicodeText , CreateBackup:=False

xlUnicodeText --> is most important

--
Regards,

Halim



"HOONHEE" wrote:

> Thank for your reply..
>
> Hmmm...
>
> Chiness use my excel program with their computer in China.
>
> When they clik "Create File" button, VBA process do converting.
> Chiness upload the result text file to Web System.
>
> When I query DB. All Chiness cracked.
> Oracel DB NLS = UTF-8
>
> Can my VBA coding convert excel to text with "UTF-8" characterset?
>
>
> --
> Everyday is a little life!!
> Thank u!!
>
>
> "Halim" wrote:
>
> > hi,
> > may be the problem occure while your windows doesnt support with asian
> > language / Chineese
> > Try to setup language option from control panel
> > --
> > Regards,
> >
> > Halim
> >
> >
> >
> > "HOONHEE" wrote:
> >
> > > Hi!
> > > First. I'm sorry. I'm not used to English. ^^;
> > > i'm using VBA in Excel(Office 2003).
> > > I used "SaveAs" Method for coversion Excel to Text File with VBA...( For
> > > uploading Oracle DB with Other Program)
> > > But.
> > > When Execel convert to Text File, Chiness words cracked during converting.
> > > One man said me.
> > > "When You convert excel to Text file.. change characterset 'UTF-8'!!"
> > >
> > > I find SaveAs Option "xlUnicodeText" FileFormat.
> > > I can't find Option about "UTF-8" fileformat.
> > >
> > > How can I convert Excel to txt file with UTF-8 encoding...
> > >
> > > If You know that. Advise me ^^;
> > >
> > > Thanks you...
> > >
> > > --
> > > Everyday is a little life!!
> > > Thank u!!
Click to expand...
 
Back
Top