Hello group,

I want to know the Code which exports data to an Access table
from an Excel worksheet and the code which imports data
from an Access table to a worksheet.

i want to run it as a macro .

Please help me with this problem.

cheers
Nuti

Hi

I am working on a webpage about this and hope to finish it next week

You can look here for information
http://www.erlandsendata.no/english/...php?t=envbadac




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


"nuti" wrote in message ups.com...
Hello group,

I want to know the Code which exports data to an Access table
from an Excel worksheet and the code which imports data
from an Access table to a worksheet.

i want to run it as a macro .

Please help me with this problem.

cheers
Nuti

Hi Ron,

I have visited the link.
But it is throwing error.-----runtime error 3265

please help me out.

cheers,
nuti

Have you set the reference in the VBA editor and are the File, Table and field names correct in the code

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


"nuti" wrote in message oups.com...
Hi Ron,

I have visited the link.
But it is throwing error.-----runtime error 3265

please help me out.

cheers,
nuti

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?

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?