Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

Exporting data into an access table

Posted by Chris on January 31, 2002 9:15 AM

I am trying to export certain data from excel into
an access database from excel is there any type of
macro or wizard that will do this. Thanks.

In Access you can go to File\Get External Data and create or append the data into an Access Table

Posted by Adam S. -(nt) on January 31, 2002 12:02 PM

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.