Community
Showing results for 
Search instead for 
Do you mean 
Reply

Identifying and Pulling data from Custom Tables using ACTREADER and Excel

New Member
Posts: 6
Country: USA

Identifying and Pulling data from Custom Tables using ACTREADER and Excel

Hello all,

 

I have setup an ODBC connection, and using that connection I'm able to successfully use Excel's Database Query feature to get access to the ACT! MS SQL database.

 

The problem I'm is having is being able to identify the custom tables I've created (using Durkin's Impact Tables Module 2011).

 

Appreciate and and all guidance in helping me achieve this objective.

 

Thanks.

 

Gordon

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Identifying and Pulling data from Custom Tables using ACTREADER and Excel

As you can see from the last image in this article, the ODBC structures can be complex:
http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html

You might contact Durkin for help with how they create tables?