googolingg.... utf8

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

googolingg.... utf8

Post by sal21 »

db.Execute "Select * Into Test1 From [Text;CharacterSet=65001;FMT=CSVDelimited;HDR=YES;DATABASE=C:\Test\].[utf8-test.csv]"


but this line of code really save a table fields in cvs with encoding UTF8?

if yes, how to set the table name and related field?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: googolingg.... utf8

Post by HansV »

The code imports a CSV file into the table Test1, using the field names in the first line of the CSV file.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: googolingg.... utf8

Post by sal21 »

HansV wrote:
22 Mar 2022, 11:47
The code imports a CSV file into the table Test1, using the field names in the first line of the CSV file.
ok clear.
but to do the opposite via sql and uncoding utf8?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: googolingg.... utf8

Post by HansV »

Sorry, no idea.
Best wishes,
Hans

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: googolingg.... utf8

Post by SpeakEasy »

In Access? Something like

Code: Select all

    DoCmd.TransferText acExportDelim, , "Table1", "d:\downloads\TestTest.csv", True, , 65001
should do the trick

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: googolingg.... utf8

Post by sal21 »

SpeakEasy wrote:
22 Mar 2022, 13:51
In Access? Something like

Code: Select all

    DoCmd.TransferText acExportDelim, , "Table1", "d:\downloads\TestTest.csv", True, , 65001
should do the trick
TKS.
but i need via ado code and vb6.