469,578 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Export table to dbf file and right codepage with DoCmd.TransferText

This is my code:

Code1:
Expand|Select|Wrap|Line Numbers
  1. 'DoCmd.OpenTable "tblImport"
  2. 'DoCmd.TransferDatabase acExport, "dBASE IV", strOutputDir,acTable,"sel_TblImport", strDbfName & ".dbf", False
  3.     '
  4. DoCmd.Close acTable, "tblImport"
================================================== ======

Code2:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acExportDelim, sImportSpecification, "sel_TblImport", strOutputDir & strDbfName & ".dbf", , , 65001
================================================== ======

In code2 i get error: "Error #3027 - Cannot update. Database or object is read-only." Everything is correct,
-- 65001 is the unicode utf8 codepage param.
-- sel_TblImport is a query
-- sImportSpecification is specification and also set to unicode


In code1 no errors but i can not give a proper codepage (unicode utf8), it must be utf8 otherwise the values in column in my dbf file are wrong.

ko.ˈpɾin.θeps <------ this word must stay unicode and not converted like this:
ko.'p?in.?eps, strange characters will be replaced with question mark.


What should i do now, i'm stuck seriously
Mar 6 '08 #1
0 2991

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.