Excel as Input Form for Another Database
 

Hi!

I just want to know how I can use excel to input data for another
database. What I mean is, I will be designing an excel sheet as a form
and add a save button on that sheet. Once the user click on the save
button, it will save the data inputted on that excel sheet to another
database, let say for example access.

It is possible?

Aga


--
aga2957
------------------------------------------------------------------------
aga2957's Profile: http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=571705

Excel as Input Form for Another Database
 

Hi Aga,

See Ole P. Erlanssen at:

http://www.erlandsendata.no/english/...php?t=envbadac


---
Regards,
Norman


"aga2957" wrote in
message ...

Hi!

I just want to know how I can use excel to input data for another
database. What I mean is, I will be designing an excel sheet as a form
and add a save button on that sheet. Once the user click on the save
button, it will save the data inputted on that excel sheet to another
database, let say for example access.

It is possible?

Aga


--
aga2957
------------------------------------------------------------------------
aga2957's Profile:
http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=571705

Excel as Input Form for Another Database
 

Gee... Thanks

--
aga295
-----------------------------------------------------------------------
aga2957's Profile: http://www.excelforum.com/member.php...fo&userid=2534
View this thread: http://www.excelforum.com/showthread.php?threadid=57170

Excel as Input Form for Another Database
 

Hi!

I used the "Use a closed workbook as a database (ADO)" for the project
that I'm doing but it returned an error.

I have inputted the code on one of my modules and a button will call
the procedure.

Once I click on the button it says 'User-define type not defined for
"cn As ADODB.Connection".

Can you tell how should I do this in VBA since I'm using excel? Thanks!


--
aga2957
------------------------------------------------------------------------
aga2957's Profile: http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=571705

Excel as Input Form for Another Database
 

Hi Aga,

Have you followed Ole's instructions:

'------------------------
The macro example 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.
'------------------------


---
Regards,
Norman


"aga2957" wrote in
message ...

Hi!

I used the "Use a closed workbook as a database (ADO)" for the project
that I'm doing but it returned an error.

I have inputted the code on one of my modules and a button will call
the procedure.

Once I click on the button it says 'User-define type not defined for
"cn As ADODB.Connection".

Can you tell how should I do this in VBA since I'm using excel? Thanks!


--
aga2957
------------------------------------------------------------------------
aga2957's Profile:
http://www.excelforum.com/member.php...o&userid=25346
View this thread: http://www.excelforum.com/showthread...hreadid=571705

Excel as Input Form for Another Database
 

Hi!

Thank you for your reply. Yes, I redid all the instructions and I go
it working finally. However, another problem is, whenever I close th
excel file and open it again, the procedure does not work. Is ther
something wrong?

Ag

--
aga295
-----------------------------------------------------------------------
aga2957's Profile: http://www.excelforum.com/member.php...fo&userid=2534
View this thread: http://www.excelforum.com/showthread.php?threadid=57170