Archive of Mr Excel Message Board

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

excel data

Posted by PN on February 04, 2002 4:14 AM

Hi, Can I export data from Excel to access database? somehow ? using VBA.

Re: excel data

Posted by Carl B on February 04, 2002 9:01 AM

Yes, but I think it would be easier from Access rather then Excel.
In Access go into the macro section and scroll down the list of commands, one is import and one of the options is from excel

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.