C
ChatsAde
I have set up an ODBC connection between a Visio 2002 diagram and an Excel
spreadsheet using the standard Add Ons.
It works fine, and I can update data in Excel, refresh the shape properties
in Visio, and Visio is updated.
My problem is that after making a number of changes in Excel, then trying to
refresh the Visio objects properties, I get an error
ODBC Error: 07001
[Microsoft][ODBC Excel Driver] Too few parameters. Expected 3.
The only way to remove this error is to go through the whole export to
database process again (losing the changes I made to the data in Excel).
Has anybody come across this before? I am facing a tedious process of making
step by step changes to identify the problem at the moment, so any help would
be greatfully received.
Thanks
Ade
spreadsheet using the standard Add Ons.
It works fine, and I can update data in Excel, refresh the shape properties
in Visio, and Visio is updated.
My problem is that after making a number of changes in Excel, then trying to
refresh the Visio objects properties, I get an error
ODBC Error: 07001
[Microsoft][ODBC Excel Driver] Too few parameters. Expected 3.
The only way to remove this error is to go through the whole export to
database process again (losing the changes I made to the data in Excel).
Has anybody come across this before? I am facing a tedious process of making
step by step changes to identify the problem at the moment, so any help would
be greatfully received.
Thanks
Ade