MS Access 2003 link/import tables with ACT7

[AllisonC]

Good day,

I have setup a OLEDB file as suggested in a earlier inquiry. However I can not get all the information needed to import, I only get the titles to import.

Once I get the information into the excel sheet how can I link this to MS Access and being able to have this as my primary source for reporting but using ACT as our daily data gathering system.

Any suggestions will be helpful.

Thank you and I look forward to hearing back.

Allison

 

[GLComputing]

OLEDB allows you to read from ACT! - ie export, not import.

What are you actually trying to achieve?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[AllisonC]

Thank you for the quick response.

I am trying to create a Sales pipeline report using ACT opportunities. We want to creat them in MS Access because we will be able make the report that will give us exactly what we want.

I am fairly new at using Access, I'm not sure if this can be done. I was able to create a report linking Business works to Access.

Looking forward to hearing from you.

 

[GLComputing]

I've not tried using Access as a reporting module. Just a thought for something that might be easier, have you had a look at

http://www.CrystalClearReports.com

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au