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?
googolingg.... utf8
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: googolingg.... utf8
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
Hans
-
- PlatinumLounger
- Posts: 4355
- Joined: 26 Apr 2010, 17:36
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 550
- Joined: 27 Jun 2021, 10:46
Re: googolingg.... utf8
In Access? Something like
should do the trick
Code: Select all
DoCmd.TransferText acExportDelim, , "Table1", "d:\downloads\TestTest.csv", True, , 65001
-
- PlatinumLounger
- Posts: 4355
- Joined: 26 Apr 2010, 17:36
Re: googolingg.... utf8
TKS.SpeakEasy wrote: ↑22 Mar 2022, 13:51In Access? Something like
should do the trickCode: Select all
DoCmd.TransferText acExportDelim, , "Table1", "d:\downloads\TestTest.csv", True, , 65001
but i need via ado code and vb6.