You can link to an Excel sheet/Table. This is an option under the file
menu - same place you would import (as I recall).

--
Regards,
Tom Ogilvy

"Sheetal " wrote in message
...
I need a macro that will import new data(from excel) into a table that
is already set up. The data will be imported every time the macro run
button is clicked.

How can i do this? there is no option in access macros that does the
new table, import table.

Please help

Thanks


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