Word XP(2002) and Excel XP(2002) cannot use new MyODBC datasources even though Access XP can on the same machine.
Further, a word document with an existing MyODBC database inserted in it, when opened in Word XP will successfully access the database.
If the field codes for the (old, working) connection are manually modified to change the SQL syntax, that still works.
Inserting the field codes to query a database manually from Word XP fails.
The failure in word is a failure to access datasource if the field code is manually entered, but it provides a message inidcating that it can't get a list of tables if using the MSQuery "insert database" in Word or Excel.
I realize this is totally inconsistent, but that't the situation. Please advise if there are any experiments that I should try.
This is running on Windows 2000, Office XP (2002) and has been observed on several machines.
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail myodbc-thread5751@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail myodbc-unsubscribe@lists.mysql.com instead.
In response to your question, I just tried an experiment and had success, so it may work for you.
I have ported the Northwind Access database to MySQL InnoDB table type. (To make it work correctly, I had to add a timestamp column to every table. This is a known issue.)
The DSN to connect to it is called NWIB on my machine.
I loaded Excel, then chose /Data/Import/New Database Query. When prompted, I pointed to the NWIB DSN. It successfully found the tables and prompted me for table to import. I chose Orders and am now looking at all the data.
I am using Office XP atop Windows XP and this worked fine. I am able to sort it and sum it etc.
hth, Arthur
----- Original Message ----- From: "Joel D Peshkin" <peshkijd@mindspeed.com> To: <myodbc@lists.mysql.com> Sent: Wednesday, July 03, 2002 4:34 PM Subject: Word/Excel XP(2002) cant use MyODBC 2.50.39
Word XP(2002) and Excel XP(2002) cannot use new MyODBC datasources even> though Access XP can on the same machine.>
Further, a word document with an existing MyODBC database inserted in> it, when opened in Word XP will successfully access the database.>
If the field codes for the (old, working) connection are manually> modified to change the SQL syntax, that still works.>
Inserting the field codes to query a database manually from Word XP fails.>
The failure in word is a failure to access datasource if the field code> is manually entered, but it provides a message inidcating that it can't> get a list of tables if using the MSQuery "insert database" in Word or> Excel.>
I realize this is totally inconsistent, but that't the situation.> Please advise if there are any experiments that I should try.>
This is running on Windows 2000, Office XP (2002) and has been observed> on several machines.>
---------------------------------------------------------------------> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before> posting. To request this thread, e-mail myodbc-thread5751@lists.mysql.com>
To unsubscribe, send a message to the address shown in the> List-Unsubscribe header of this message. If you cannot see it,> e-mail myodbc-unsubscribe@lists.mysql.com instead.>
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail myodbc-thread5860@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail myodbc-unsubscribe@lists.mysql.com instead.
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
