Office Data Connector

[aaron kempf]

Why is it that Access can't import data from Office Data Connectors?

Are they only used for DAP?

-aaron

 

['69 Camaro]

Hi, Aaron.

Why is it that Access can't import data from Office Data Connectors?

The key phrase is "data connectors." These files are interfaces to the data
source, not the actual data source itself. These files hold no data for
Access to read or link to.

Think of it like a book cover on a book. The book cover is the interface
(title, author, protective binding for the pages, et cetera), and the book's
pages are the data source. If you found a book with the title, "TO SERVE
MAN," you wouldn't know exactly what information was inside the book. You'd
have to open the book (the data source) itself to find out that it was a
Kanamit cookbook. 8-O

Are they only used for DAP?

No. They can be used for Web applications built by any Web page building
tool, where the Web application will use IIS.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[aaron kempf]

I just think that it is funny that Access can import form an ODBC
connection, but it can't import from an ODC connection

 

['69 Camaro]

Hi, Aaron.

I just think that it is funny that Access can import form an ODBC
connection, but it can't import from an ODC connection

The ODC is an extra layer that Web applications can use from IIS to get to
the ODBC connection to read from the data source. Access uses the ODBC
connection to read from the data source. Why would you want extra layers of
communication? It's like traveling from Los Angeles to San Franciso via New
York.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[aaron kempf]

I just like how I can open a query connection object in Excel and it gives
me a brand new pivotTable based off of that OLAP connection.. that is pretty
smooth.

So are ODC just the connection string information for the
DataSourceControl??

I do a lot of OWC work with the PivotTable list; I've always been trying to
get a DSC to work against OLAP-- then end-users could select what cube they
want to work against

 

['69 Camaro]

Hi, Aaron.

So are ODC just the connection string information for the
DataSourceControl??

Open an ODC file yourself and take a look. If you've worked with networked
databases for any length of time, you won't find anything surprising.

I do a lot of OWC work with the PivotTable list; I've always been trying to
get a DSC to work against OLAP-- then end-users could select what cube they
want to work against

My clients use different tools for data warehousing and reporting, so I'm
afraid that I can't give you any helpful advice with your particular tools.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)