MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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