Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
programming
Can a macro be created to save information from excel to access database?
-- help a friend help you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
programming
Yes
"ernie" wrote in message ... Can a macro be created to save information from excel to access database? -- help a friend help you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
programming
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? -- help a friend help you "Steve Yandl" wrote: Yes "ernie" wrote in message ... Can a macro be created to save information from excel to access database? -- help a friend help you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
programming
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 -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=521588 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
programming
I'm not an excel expert. Your help in creating that macro would be deeply
appreciated. thanks for the info -- help a friend help you "systemx" wrote: 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 -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=521588 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using programming to copy worksheets data only | Excel Discussion (Misc queries) | |||
Excel is written in which programming language ? | Excel Discussion (Misc queries) | |||
Excel/VBA programming | Excel Discussion (Misc queries) | |||
Linear Programming | Excel Discussion (Misc queries) | |||
Reversing the contents of a List without programming | Excel Worksheet Functions |