Macro to get from excel into Access
 

Is it possible to write a macro in excel that exports directly into a
access database?
Basically, I have a macro that takes a flat file, formats in Excel an
then saves it as excel format. I then want to open it in access as
table.

Is there an easy way to do this?

And

--
Message posted from http://www.ExcelForum.com