dbTalk Databases Forums  

How to learn Office Automation with Access?

comp.databases.ms-access comp.databases.ms-access


Discuss How to learn Office Automation with Access? in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pw
 
Posts: n/a

Default How to learn Office Automation with Access? - 11-29-2004 , 09:23 PM






Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

Reply With Quote
  #2  
Old   
Alan Webb
 
Posts: n/a

Default Re: How to learn Office Automation with Access? - 11-30-2004 , 12:02 AM






PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote

Quote:
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)



Reply With Quote
  #3  
Old   
Bob Alston
 
Posts: n/a

Default Re: How to learn Office Automation with Access? - 11-30-2004 , 08:14 AM



Alan Webb wrote:
Quote:
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7mpnq01er6ogalqf3eloj7paeg4ogukf0f (AT) 4ax (DOT) com...

Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)



You can download this Microsoft 2000 Automation Help File
http://support.microsoft.com/default.aspx?kbid=260410

Bob


Reply With Quote
  #4  
Old   
pw
 
Posts: n/a

Default Re: How to learn Office Automation with Access? - 11-30-2004 , 09:18 PM



Quote:
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
Thank you Alan. I'll try the help files again. Hadn't had too much
success, especially with Excel's.



Quote:
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7mpnq01er6ogalqf3eloj7paeg4ogukf0f (AT) 4ax (DOT) com...
Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)


Reply With Quote
  #5  
Old   
pw
 
Posts: n/a

Default Re: How to learn Office Automation with Access? - 11-30-2004 , 09:18 PM



Quote:
Alan Webb wrote:
PW,
Start with the help files. Excel and Access play very nice together. You
can use data from either in either without coding anything.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:7mpnq01er6ogalqf3eloj7paeg4ogukf0f (AT) 4ax (DOT) com...

Hi,

I use Visual FoxPro all the time to import and export data from and to
Excel (creating workbooks in code, etc...).

There is an excellent book on how to do this with VFP from
Hentzenwerke Publishing. Is there a good book on how to do this using
MS Access? If not, where else should I look? I am concerned with
Word too, and perhaps Powerpoint.

We are presently using A97 but may be converting our application to
A2003.

Regards,


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)



You can download this Microsoft 2000 Automation Help File
http://support.microsoft.com/default.aspx?kbid=260410

Bob
Just downloaded it. Thanks for the link Bob!


-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.