I need a macro that will import new data(from excel) into a table tha
is already set up. The data will be imported every time the macro ru
button is clicked.

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

Please help

Thank

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

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/

It's a bit noddy, but have you tried in access, link table, then selec
the excel file and worksheet

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

i don't want to link table, because I am creating a new document
everyday - daily entries. To avoid the documents getting too big, I
create new ones every day.

any other ideas?

Thanks

Sheetal


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