Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

access

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

Hello,

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

Jan

Re: access

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.