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