Urgent Help!!! Excel's Marco Auto Convert to Access's db

[Paul Chan]

Hello All. Thank you for reading my post first.

I have a excel sheet, it contain the database.
And I want to set a Marco Function or VBA etc,
which can auto get the data from excel sheet and
import into a Access's database.

Thank you again.

 

[jaf]

Hi Paul,
You really don't need VBA to do this.
In Access do file>get external data.
Choose Excel as the filetype. (named ranges work best)
You can choose to import or link the data.

If you link the data the Access db will update whenever the XL sheet is
changed.