vba连接excel插件

Oraxcel (TM) User Manual - readme.txt - This document provides the information on how to install the program and how to operate it. This document is split into the following sections: 1. Installation of Oraxcel (TM) 2. UnInstalling Oraxcel (TM) 3. Connecting to Oracle 4. Query the database 5. Insert data into the database Please also refer to the manual.doc file for more information. 1. Installation of Oraxcel (TM) ========================== The installer.xls spreadsheet helps you to install or load Oraxcel. Alternatively you can follow the instructions below. If you want to just have a go with the utility without actually installing it, you can open it in Excel using the normal File-Open menus in Excel. When you want to install it such that it loads whenever you load Excel, do the following: - Load Excel. - Choose the menu item Tools-AddIns... - The Add-Ins window will load. - Push the Browse button and select oraxcel.xla. - You can either choose to include in the addin library or leave it where it is at the moment. - Push the OK button to close the Add-Ins window. - Restart Excel. - If it is ok you'll have the new menu item Oracle by now. 2. UnInstalling Oraxcel (TM) ======================= The installer.xls spreadsheet helps you to (un)install or (un)load Oraxcel. Alternatively you can follow the instructions below. When Oraxcel (TM) is not loading automatically when you start Excel you don't have to do anything. When Oraxcel (TM) is loading automatically when starting Excel you will have to perform the following actions: - Load Excel. - Choose the menu item Tools-AddIns... - The Add-Ins window will load. - Un-tick the Oraxcel (TM) check box. - Push the OK button to close the Add-Ins window. - Restart Excel. - If it is ok, you don't have the menu item Oracle available. Since the files will still be on your computer you can remove the file oraxcel.xla if you want to free your disk space. 3. Connecting to Oracle ======================= - Choose Oracle-Connect. - The Oracle-login window appears. - Complete the form and press the OK button. - On succesfull login the other menu items in the Oracle menu will be enabled (not grayed out). Please refer to the questions and answers section of this document when you get errors. 4. Query the database ===================== - Select a cell on your spreadsheet you want Oraxcel (TM) to start pasting the results in. - Choose Oracle-Query - The Oracle-query window appears. - Type your SQL in the large text box. - Push the OK button to perform the query. A few things can happen now: 1 You get an error message from Oracle and the Oracle-query dialog disappears. Choose Oracle-Query again to re-invoke the dialog screen and change the SQL. 2 You get a dialog box which actually tells you how many rows and columns are fetched. If it reflects a large amount of data, I recommend to do it in smaller chuncks by changing the SQL. Press Cancel to cancel or OK to proceed. 3 You are prompted that the tool is unable to paste all the data in the sheet. Try to make the result set smaller by changing the SQL or choose another cell in the spreadsheet to start pasting the data from. Using the above method has 2 disadvantages. You'll lose your SQL when you close Excel and the SQL is limited to 255 characters. To get around this, Oraxcel (TM) is able to use the text in cells you select. - Write your SQL in 1 or more cells in the spreadsheet. - Select all cells that make up the SQL. - Choose Oracle-Query. - The Oracle-query window appears. - Tick the "Use selected cells as SQL statement" tick box. - The large text box disappears from the window. - Push the OK button to perform the query. 5. Inserting data into the database =================================== - Choose Oracle-DataEntry - The Data Entry window appears. - Push the Select Table/View button. - The Schema.Table Selection popup appears. - Type or choose a scheme (owner) and a table or view - Push the Select Button. - Oraxcel will validate the input and return to the Data Entry window. - Push OK to continue. - The dialogs will disappear from your screen. - A new worksheet is added to your workbook (.xls file) - A table is created to assist you to do the insert. - Complete the form by putting values in for the mandatory columns. - Press the Insert button to do the insert. When Oracle finds an error it will shout. Correct the error and try it again. You can push the insert button as many times as you wish.