[AccessD] Word documents and MS Access

Jim Lawrence accessd at shaw.ca
Tue May 22 04:15:33 CDT 2007


Hi Shamil:

Thanks to that. Much appreciated. Now I have to get down to it.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Monday, May 21, 2007 12:04 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Word documents and MS Access

Hello Jim,

VB6/VBA uses Unicode for String variables internally.
If you will use MS Word Automation then you also use Unicode when getting
text from MS Word tables. MS Access (since version 2000) also uses Unicode
for text fields.
Therefore I think that "2. Reading data out of Word documents into an Access
database" doesn't need any specific handling including reading Cyrilic
chars, which will be in Unicode.
I have just tested this sample I mentioned before -
http://smsconsulting.spb.ru/shamil_s/topics/dfromw95.htm - it works OK with
Cyrillic chars getting properly into MS Access 2003 tables.

As for "Double-byte Character Sets; using them with Word documents and
Access databases." - what do you mean by DBCS - is that a synonym of Unicode
or MBCS?

Have a look - http://en.wikipedia.org/wiki/DBCS :
"Some people use DBCS to mean Unicode, specifically UTF-16, while other
people use the term DBCS to mean older (pre-Unicode) code pages that use
more than one byte per character. Shift-JIS, GB2312 and Big5 are a few code
pages that can contain more than one byte per character, but even using the
term DBCS for these code pages is incorrect terminology because these code
pages are really MBCS (MultiByte Character Sets). Some IBM mainframes do
have true DBCS code pages, which contain only the double byte portion of a
multibyte code page."

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, May 21, 2007 9:04 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Word documents and MS Access

Hi Shamil:

Thanks for the links. I wonder how this code would handle 4 byte character
sets and of course the information in the document would have to be in table
format. Does this code handle Cyrillic characters? Are they just another 256
byte character set?  

Thanks again
Jim   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Monday, May 21, 2007 7:27 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Word documents and MS Access

Hello Jim,

Have a look at these topics with code samples:

http://smsconsulting.spb.ru/shamil_s/topics/dfromw95.htm 
http://smsconsulting.spb.ru/shamil_s/topics/w95imp.htm

HTH

--
Shamil
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, May 21, 2007 12:20 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Word documents and MS Access

Hi All:

I have two questions. They are both related. A client has approached me with
a particular project and I am wondering if anyone has experience with the
following:

1. Double-byte Character Sets; using them with Word documents and Access
databases.
2. Reading data out Word documents into an Access database.

TIA
Jim  

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list