Community
Showing results for 
Search instead for 
Do you mean 
Reply

OLEDB2 or direct server query in excel

Tuned Listener
Posts: 45
Country: Poland

OLEDB2 or direct server query in excel

What is the diffrence in using oldeb2 or sql query to get info from act , i can create good complicated query that can give me exact info about act , the minus is i must use sql user. but i do not know how i can create more complicated ask with act oledb2 coust there is just only one table(view) to take from .    is there a way to create view under SQL and use it with act oledb or oledb2 ?