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