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

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!!

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

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!!

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

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!!

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

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!!