linking datawarehouse to a table

[AccessNewbie72]

Hi guys,

I have been linking text delimited file to my Access table. The text delimited file is generated by a report run by our in-house system. I've been able to do this. Now, I want to learn how to link a datawarehouse (ODBC?) cube to Access. Is there a tutorial somewhere I can perhaps start? I tried to search this form by typing "Linking datawarehouse" I only found one post.

Thanks

 

[AccessNewbie72]

Hello,

Just wondering if I didn't ask the proper question? Could somebody help me?

If this was something that's too complicated to explain..could somebody at least point me to some kind of tutorial or something?

Thank you in advance.

 

[gemma-the-husky]

try manually linking a table

do files, import, link, then try to find an odbc datasource for your datawarehouse in system or machine data sources - you should recognize the odbc driver name.

the connection requirements are often different for all odbc sources - you will probably have to identify a table, and will need passwords etc

if you can do it manaually, you can do it by code also.

the datawarehouse manual may have more info about how to connect.

 

[AccessNewbie72]

try manually linking a table

do files, import, link, then try to find an odbc datasource for your datawarehouse in system or machine data sources - you should recognize the odbc driver name.

the connection requirements are often different for all odbc sources - you will probably have to identify a table, and will need passwords etc

if you can do it manaually, you can do it by code also.

the datawarehouse manual may have more info about how to connect.

Hi Gemma,
Thanks for the response. I've tried linking it doing the way I normally would, but for whatever reason Access didn't recognize the file type (the datawarehouse cube).

I am not sure what you mean by passwords, etc...

I will keep searching on this issue, but would still welcome any inputs from all the experts here.

Thanks again guys

 

[Programmer]

I know how to link the tables in the ODBC to access. However, how do I bypass putting my password into everytime I run a query? VBA? If you know how to do it with VBA please provide feedback.

 

[gemma-the-husky]

i think it depends on how and whether the ODBC connection deals with the password, or whether you can use a trusted connection. they all seem different.

 

[AccessNewbie72]

I know how to link the tables in the ODBC to access. However, how do I bypass putting my password into everytime I run a query? VBA? If you know how to do it with VBA please provide feedback.

Hi Programmer...could you show me how to do the basic link?

The way I do is go to File-external data-link and pick "ODBC database" correct?

I wonder why i'm trying this from home, it does have the option for ODBC database file type, but when I try to do this at work, it doesn't provide the same option...I think I use both Access 2000.