Check Register Data Table

[scottpdann]

I want to be able to download my check registers automatically using excel or Acesses data functions.

Any thoughts on how to do this?

What tables should i look at?

 

[klewis10367]

You could schedule a DTS package and download it to either excel or access. Look at the CM20200.

 

[scottpdann]

What is a DTS Package?

 

[klewis10367]

Do you use Enterprise Manager for SQL?

 

[scottpdann]

No,

I am running on MSDE.

 

[klewis10367]

Sorry, I am not familiar with MSDE i would be of no help.

 

[jazgeek]

MS Access odbc pull using some sort of macro program to fill in the blanks?




-----------
and they wonder why they call it Great Pains!

jaz

 

[scottpdann]

What TABLES do I pull from?

 

[winthropdc]

As mentioned by Klewis, the CM_Transaction table is called CM20200.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.