Encerrado

strange data characters in Microsoft Access

I am importing ACT! data (dBase files) into Microsoft Access. The data I am importing has international characters in it.

The international (accented characters) are not coming across properly.

The first screenshot shows the Access data table.

As you can see in row 21, COMPANY ends with a chinese character (Albert-Ludwig-Universit舩)

This is not correct it should look like this -

(Albert-Ludwig-Universität)

However, If I copy the COMPANY data from the Access data table view and paste it into the Visual Basic Immediate Window it pastes correctly. (see 2nd screenshot).

Why is this happening? How can i get the data to appear correctly in the Access data table view?

I have attached a zip file that contains the screenshots as well as a Microsoft Access 2000 .mdb file that contains the data table.

## Deliverables

I need either

A. An explanation of how to change the settings in Microsoft Access to properly display the characters.

OR

B. A vb function that will convert the strings.

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP, 2K,

Access 2000,XP

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Veja mais: working as a seller in a company, work in act, why should a company hire you, web dbase, strange engineering, party characters for hire, mdb files, hire microsoft access, company for microsoft installation, microsoft visual, characters for hire, microsoft company, chinese characters, hire a chinese coder, data importing, characters, albert, php data table, access file convert program file, access program convert

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #3305321

6 freelancers estão ofertando em média $45 para esse trabalho

vw1241458vw

See private message.

$63.75 USD in 3 dias
(6 Comentários)
2.5
julienbrunelle

See private message.

$17 USD in 3 dias
(2 Comentários)
2.4
jagawins

See private message.

$46.75 USD in 3 dias
(9 Comentários)
1.3
crrangarajan

See private message.

$25.5 USD in 3 dias
(3 Comentários)
0.5
honesttradervw

See private message.

$32.3 USD in 3 dias
(2 Comentários)
0.0
biljaibobi

See private message.

$85 USD in 3 dias
(0 Comentários)
0.0