I have a pivot table that houses data for the entire corporation and it is pulling data from one large access table.
We have users that will need to only see the data for themselves and/or their department and they will need to see it in the same pivot table format.
I can do it through access...
Can anyone tell me how to link an AS400 database into a SQL 2005 server using the iSeries Access ODBC Driver? It works perfectly to link into Access 2003, but I can't get it to link and I also can't get it to import data using the DTS package. Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.