asked on
Excel linked to ODBC
Is it possible to have a spread sheet linked via a ODBC to the AS400's DB2?
Then when I press a refresh Button (a macro to fire off the odbc connection and update records)
the spreed sheet connects the link and pulls the data in.
I know I will have to map the feilds somehow too...
Then when I press a refresh Button (a macro to fire off the odbc connection and update records)
the spreed sheet connects the link and pulls the data in.
I know I will have to map the feilds somehow too...
Microsoft Excel
Last Comment
royhsiao
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Please check the following:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/db2_odbc.html
Here is about Excel query
http://www.exceluser.com/explore/msquery1_1.htm
You could also post another question to get more attention.
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/db2_odbc.html
Here is about Excel query
http://www.exceluser.com/explore/msquery1_1.htm
You could also post another question to get more attention.
where can I build it in Excel?
Thanks