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