MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jan on July 19, 2001 5:22 AM


is there a macro that exports data from an excel sheet into an access-database? The data (which is being generated every day) has to be added to a databas (the archive).

Thanks for help


Posted by Carole on July 19, 2001 6:01 AM

You can do this from ACCESS. If you want to append data to a table, open the table and use the FILE/GET EXTERNAL DATA/IMPORT path.