A
aaron kempf
Why is it that Access can't import data from Office Data Connectors?
Are they only used for DAP?
-aaron
Are they only used for DAP?
-aaron
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
6
'69 Camaro
Hi, Aaron.
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
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.)
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.)
A
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
connection, but it can't import from an ODC connection
6
'69 Camaro
Hi, Aaron.
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.)
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.)
A
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
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
6
'69 Camaro
Hi, Aaron.
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.
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.)
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.)