New Macro

  • Thread starter Thread starter Sheetal
  • Start date Start date
S

Sheetal

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
 
You can link to an Excel sheet/Table. This is an option under the file
menu - same place you would import (as I recall).
 
It's a bit noddy, but have you tried in access, link table, then selec
the excel file and worksheet
 
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
 
Back
Top