Accessing .xls or .mdb files in a Unix directory

mctny · Post by **mctny** » Sat Jul 29, 2006 10:55 am

can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

shawn_ramsey · Post by **shawn_ramsey** » Sat Jul 29, 2006 11:43 am

mctny wrote:can you please describe me how to do this?
ray.wurlod wrote:You have the alternative of accessing through SQL Server.

You can use SQL Server to create a linked server to an ODBC driver. You would then create views on the sql server that select data from the linked servers. At that point they appear to DataStage as normal views in a SQL Server database. You can then use the SQL Server ODBC driver on the Unix server.

mctny · Post by **mctny** » Sat Jul 29, 2006 12:24 pm

thank you very much Shawn. does anybody know how to make a direct connection from SQL server to MS Access?

shawn_ramsey wrote:
mctny wrote:can you please describe me how to do this?
ray.wurlod wrote:You have the alternative of accessing through SQL Server.
You can use SQL Server to create a linked server to an ODBC driver. ....

kcbland · Post by **kcbland** » Sun Jul 30, 2006 8:12 am

same way