By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Share this question for a faster answer!
Share on Google+

Post your reply

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