programming

E

ernie

i have this excel workbook i need to save the results of some calculations to
an access database for keeping a history and making reports which i can
easily access and manipulate later down the years. instead of saving the
workbook with a different file name all the time. when it is time to lookup
certain information it will be more difficult to go through several hundreds
of saved excel files rather than just searching an access database. I would
like to know how to create a macro which can let me accomplish this task.
saving from excel to access. How do i go about this? do you have any links to
sites i can read up and understand macros? Do you know the formulas i can use
to make it work?
 
S

systemx

Hi Ernie,

One of the easiest ways to transfer data from one Office application to
another is by using the import/export wizards. They can accessed through
the 'File' menu and it literally takes seconds to perform the function.

If you want to export from excel (instead of opening Access and
importing data) - you may need to install some additional files from
your MS Office Installation CD.

You could also create macro in either excel or access, that will
import/export data from/to either an existing file or a new file - then
automatically save that file with a name of your choice. The macro
should be relatively simple to create.

Cheers

Rob
 
E

ernie

I'm not an excel expert. Your help in creating that macro would be deeply
appreciated.

thanks for the info
 
Top