Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help. Trying to use Word as a form with Excel as a database | Excel Discussion (Misc queries) | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How do I create a database from an Excel form? | Excel Discussion (Misc queries) | |||
how to input an ultimatum in an excel database... | Excel Discussion (Misc queries) | |||
connect a form to excel database | Excel Discussion (Misc queries) |