C
Charles
I use Microsoft Access 2000 at work. I have a database
that I have to update on a recurring basis. My supervisor
has an Excel 2000 spreadsheet that he wants updated, too.
Since the data I input into each application is identical,
is there a way to write a program that takes the Access
information and posts it into the spreadsheet
automatically? I know it can be done but being somewhat
new to these applications, I do not know where to start.
Would I write a VBA module to accomplish this? Does anyone
know of a websites that explains this process or know of a
good book that I can pickup? Thanks in advance.
that I have to update on a recurring basis. My supervisor
has an Excel 2000 spreadsheet that he wants updated, too.
Since the data I input into each application is identical,
is there a way to write a program that takes the Access
information and posts it into the spreadsheet
automatically? I know it can be done but being somewhat
new to these applications, I do not know where to start.
Would I write a VBA module to accomplish this? Does anyone
know of a websites that explains this process or know of a
good book that I can pickup? Thanks in advance.