what shuold be the reference?

From the website :

The macro examples assumes that your VBA project has added a reference to the ADO object library.
You can do this from within the VBE by selecting the menu Tools, References and selecting Microsoft ActiveX Data Objects x.x Object
Library.
Use ADO if you can choose between ADO and DAO for data import or export.


correct me if iam wrong---
---does the code take the excel sheet which is open/from the excel from
which the macro is run?

It use the active sheet but you can include the sheet name if you want

Range("C1")

' Example: ADOImportFromAccessTable "C:\FolderName\DataBaseName.mdb", _
"TableName", Range("C1")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"nuti" wrote in message ups.com...
what shuold be the reference?

correct me if iam wrong---
---does the code take the excel sheet which is open/from the excel from
which the macro is run?