Home > Excel Help Portal > Using External Data with Excel

<<  (Page 3)  Previous              Next  (Page 2)  >>

Using External Data with Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses using external data in
Microsoft Excel.

1. Office 2000, my experience in installing - Progress report Title:    Office 2000, my experience in installing - Progress report Location:   ofc2000.htm Author:    David McRitchie    msn.com"DMcRitchie@   also DMcRitchie@msn.com  Document Creation Date:   July 12, 1999 FWIW, Word says I last updated this document (mm/dd/yyyy) on 07/25/1999 9:40 AM. Last... Keywords: Add-In, Sorting, Days, Download, DDE, Export, Sales, Format, Errors, Sounds, Printing, Macro, VBA, Setup, CD-ROM, Files, Toolbar, Text Files, HTML, Links, Web, Comments, Window

 
2. How to transfer Data to an Excel Workbook by Using Visual Basic .NET This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual Basic .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works... KB#306022. Keywords: Query, Download, ActiveX, OLE, SQL, XML, Fonts, Format, Styles, Arrays, Errors, Defined Name, Clipboard, Combo Box, VBA, Object, Files, Text Files, Web, Parse, DB

 
3. Clip Gallery General Troubleshooting Tips Part 1 of 2 This article contains information to help you troubleshoot problems you may encounter when you start Microsoft Clip Gallery from another program. This article covers the following types of errors: Server Application or Source File cannot be... KB#162124. Keywords: Query, Dates, DLL, Export, OLE, Colors, Errors, Startup, Object, CD-ROM, Corrupted, Error Message, Files, Registry, Window

 
4. Methods for Transferring Data to Excel from Visual Basic This article discusses numerous methods for transferring data to Microsoft Excel from your Microsoft Visual Basic application. This article also presents the advantages and the disadvantages for each method so that you can choose the solution... KB#247412. Keywords: Text Box, Query, Download, DAO, DDE, OLE, SQL, Fonts, Format, Arrays, Errors, Defined Name, Printing, Clipboard, Macro, Object, VBA, Files, Text Files, Parse, DB

 
5. How to create a Smart Tag DLL in Visual Basic for Use in Office XP Smart Tags are a technology introduced with Office XP that provide Office users more interactivity with the content of their Office documents. A Smart Tag is an element of text in an Office document that is recognized as having custom... KB#286267. Keywords: Download, ActiveX, DLL, XML, Arrays, Errors, Class, VBA, Macro, Object, Registry, Smart Tag, Web, Window

 
6. How to Dismiss a Dialog Box Displayed by an Office Application with Visual Basic When you are automating an Office application from Visual Basic (VB), the Office application may display a dialog box. The dialog box causes the Visual Basic application to appear to stop responding (or hang) because VB is waiting for the dialog... KB#259971. Keywords: ActiveX, Errors, Password, Printing, Class, VBA, Object, File Name, Web, Window

 
7. ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel Workbooks The ExcelADO.exe sample illustrates how you can use ActiveX Data Objects (ADO) with the Microsoft Jet OLE DB 4.0 Provider to read and write data in Microsoft Excel... KB#278973. Keywords: Query, Download, ActiveX, DAO, Microsoft Access, OLE, Format, Formulas, Defined Name, Macro, Object, VBA, Files, Templates, Web, Window, DB, OFFSET

 
8. How to develop DatabaseDriven Smart Tags for Office by Using Visual Basic for Windows Smart tag providers, for use in Office applications, are developed as ActiveX dynamic-link libraries (DLLs). Smart tag providers expose a visual, on-screen graphical user interface (GUI) when a user types a word or phrase that the provider... KB#305799. Keywords: Download, ActiveX, DLL, SQL, XML, Symbol, Class, VBA, Macro, Object, Registry, Smart Tag, HTML, Internet Explorer, Web, Window

 
9. How to configure Office applications for automation from a COM+/MTS package Lists the problems you should be aware of when you automate from within a COM+/MTS package informaiton, and the provides steps to configure an Office application for automation from a COM+/MTS... KB#288368. Keywords: DLL, Microsoft Access, Errors, Password, Startup, Printing, VBA, CD-ROM, Registry, Web

 
10. How to query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET. Create Sample Excel Worksheet Start Microsoft Excel, and create a new worksheet. Add the... KB#311731. Keywords: Text Box, Query, OLE, SQL, XML, Class, Object, VBA, File Name, Files, Web, Comments, Window, DB

 
11. How to import Data into SQL Server from Excel This step-by-step article demonstrates how to import data from Microsoft Excel worksheets into Microsoft SQL Server databases by using a variety of methods. Description of the Technique The samples in this article import Excel data by using:... KB#321686. Keywords: Query, ActiveX, DAO, Import Data, Microsoft Access, OLE, SQL, Format, Object, VBA, Links, DB

 
12. Using a field alias in Query does not work with some thirdparty databases When you try to use Microsoft Query to return data from some third-party databases into Microsoft Excel, apostrophes (') around alias names can cause the query to fail. The error message that you receive depends on the data source that you... KB#298955. Keywords: Query, Dates, Download, SQL, Third-Party, Errors, PivotTables, Error Message, File Name, Files, Registry, Web

 
13. How to retrieve Metadata from Excel by Using the GetOleDbSchemaTable Method in Visual Basic .NET This step-by-step article describes how to retrieve table and column metadata from Microsoft Excel data sources by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet.... KB#318373. Keywords: Query, ActiveX, OLE, Format, Styles, Class, VBA, Object, DB

 
14. General Information about Microsoft Office Encryption This article describes changes in encryption file properties in Microsoft Office 2003 and Microsoft Office XP. Earlier versions of Office do not encrypt file properties. Office encrypts file properties by using supported algorithms. The... KB#290112. Keywords: Export, Password, Internet Explorer

 
15. How to transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual... KB#307021. Keywords: Export, Microsoft Access, XML, Format, Styles, Errors, Object, VBA, Files, HTML, Window

 
16. How to activate a Perpetual License in Office XP Programs This step-by-step article describes how to activate the perpetual license version of Microsoft Office XP. The same procedure can also be used for any stand-alone version of Microsoft Access 2002, Microsoft Excel 2002, Microsoft FrontPage... KB#293192. Keywords: Microsoft Access, Files

 
17. Information about how to extract Office file formats and schemas Describes several methods for extracting file format or schema information for Microsoft Excel, Microsoft PowerPoint, or Microsoft Word. If these methods are not satisfactory, a license program is also... KB#840817. Keywords: Download, API, XML, Format, Printing, Files, Text Files, HTML, Web

 
18. How to export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel Use this step-by-step guide to populate a DataGrid Web server control on an ASP.NET WebForm and then export the contents of the DataGrid to Microsoft Excel. Techniques This article describes two techniques for exporting the data in the DataGrid... KB#317719. Keywords: Export, Microsoft Access, SQL, Format, VBA, HTML, Internet Explorer, Web, Window

 
19. How to transfer Data to Excel by Using SQL Server Data Transformation Services SQL Server Data Transformation Services (DTS) is a powerful tool that you can use to easily transfer data between OLE DB data sources, transforming that data in the process (if you chose to do so). This article describes how to use the... KB#319951. Keywords: Export, OLE, SQL, Errors, VBA, File Name, Files, DB

 
20. How to automate Excel Text to Speech in Another Office Program This step-by-step article explains how you can use the Text to Speech functionality of Microsoft Excel in other programs, including Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Microsoft Excel is the only Microsoft Office XP... KB#287120. Keywords: OLE, Errors, Speech, VBA, Macro, Object, Web

 
21. How to get Windows Status Information from Windows API in Excel 2000 In Microsoft Excel you can programmatically obtain system status information and display it in a worksheet. This step-by-step article provides a sample Microsoft Visual Basic for Applications Sub procedure that displays the following information... KB#213267. Keywords: API, Format, VBA, Macro, Web

 
22. ADO Inserts Data into Wrong Columns in Excel When you use ADO to insert new rows of data into a Microsoft Excel worksheet, if the data includes fields that contain empty string values, ADO may insert the data values of subsequent numeric fields into the wrong columns in Excel. This... KB#314763. Keywords: Query, ActiveX, Export, OLE, SQL, Errors, VBA, Object, Error Message, DB

 
23. GetObject and CreateObject Behavior of Office Automation Servers This article discusses the different behaviors that occur when you use the GetObject and CreateObject functions with various versions of Microsoft Office applications. GetObject and CreateObject are functions that are provided by Microsoft... KB#288902. Keywords: ActiveX, API, OLE, Errors, Class, Object, VBA, Web, Window

 
24. How to Obtain the Window Handle for an Office Automation Server This article demonstrates how to obtain the window handle of an Microsoft Office application while automating that application from Visual... KB#258511. Keywords: API, Microsoft Access, Class, VBA, Object, Window

 
25. How to Prevent File Corruption The More Information section of this article discusses features available in Microsoft Excel that are designed to help prevent data loss. It also discusses ways to prevent file... KB#149235. Keywords: Third-Party, Startup, AutoSave, Files, Templates

 
26. How to Retrieve a Table from Access into Excel Using DAO In the versions of Microsoft Excel listed above, you can use Data Access Objects (DAO) in Visual Basic for Applications to retrieve a table from Microsoft Access. To provide an example of how you can use DAO to retrieve a table from Microsoft... KB#146406. Keywords: DAO, Microsoft Access, Fonts, Errors, VBA, Macro, Object, Web

 
27. RTD Server Does Not Send Update Notifications to Multiple Excel Instances When you use multiple instances of Excel with your RealTimeData (RTD) server, you may receive the following message: The real-time data server 'servername.classname' is not responding. Would you like Microsoft Excel to attempt to restart the... KB#284883. Keywords: Dates, ActiveX, Errors, Class, VBA, Object, RTD

 
28. How and Why Unique Identifiers Are Created in Office Documents When you create a document in any of the programs listed above, a unique identifier may be created within the document. This article explains how and why these unique identifiers are created in documents, and provides two methods you can use to... KB#222180. Keywords: Download, Third-Party, Setup, Web

 
29. How to remove Template Listings in Excel This article describes how to remove recently used templates from the most recently used (MRU) files list on the File menu and from the Recently used templates list in the New Workbook task pane. back to the top Save Existing Registry... KB#822644. Keywords: Export, Sales, File Name, Files, Registry, Templates

 
30. How to use the Undo Feature with Inserted Objects in Office XP Programs When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and then you deactivate and reactivate the inserted object, the Undo command may behave differently... KB#290148. Keywords: Charts, Microsoft Access, Object, Toolbar

 
31. How to remove Template Listings in Excel This article describes how to remove recently used templates from the Most Recently Used (MRU) files list on the File menu and from the New from template list in the New Workbook task pane.WARNING: If you use Registry Editor incorrectly, you may... KB#288363. Keywords: Export, Sales, File Name, Files, Registry, Templates

 
32. How to Use DAO to Append the Records in Two Tables In the versions of Microsoft Excel listed at the beginning of this article, you can use DAO (Data Access Objects) to manipulate data in external databases. This article provides a macro example that demonstrates how you can append the records from... KB#141686. Keywords: DAO, SQL, VBA, Macro, Object, Web, DATE

 
33. How to Determine the Path for an Office Application This article includes sample code that illustrates how you can programmatically determine the installation path for a Microsoft Office application given the ProgID for that... KB#240794. Keywords: API, DLL, Class, VBA, Registry

 
34. How to Append an Excel Worksheet to a Database Using DAO The example code in this article demonstrates how to append the data from a Microsoft Excel worksheet to a table in a Microsoft Access database (.mdb). The code uses the SQL INSERT INTO statement to append the records from the Microsoft... KB#145826. Keywords: Query, DAO, Microsoft Access, SQL, VBA, Macro, Object, Web

 
35. How to clear the Most Recently Used List in Office Programs This article describes how to clear the Most Recently Used list (MRU) for the Microsoft Office programs listed at the beginning of this article. To clear the MRU, follow the steps for the program that you are using. Microsoft Access, Excel,... KB#313454. Keywords: Export, File Name, Files, Registry, Web

 
36. How to Obtain BuiltIn Constant Values for an Office Application Microsoft Office applications can act as ActiveX Servers. They provide client applications design-time access to an Object library, or type library, that enables client applications to view an Office application's objects, properties, methods,... KB#239930. Keywords: ActiveX, DLL, Microsoft Access, Errors, Class, VBA, Object, Files, HTML, Window

 
37. Error Messages in Programs That Use Word 2000 with Norton AntiVirus Installed When you use one of the Microsoft Office programs listed at the beginning of this article, and you use a feature that requires the functions of Microsoft Word, you may experience one of the following symptoms: When you try to insert a Microsoft... KB#243579. Keywords: Third-Party, Errors, Printing, Object, Error Message, Registry

 
38. How to Open XML Files in Excel In Microsoft Excel, you can open and save Extensible Markup Language (XML) files. This article describes how XML files are displayed when you open them in... KB#827294. Keywords: XML, Format, Styles, Errors, Files, Web

 
39. How to configure a Policy Setting to Disable Password Protection for Microsoft Access 2002, Microsoft Excel 2002, and Microsoft Word 2002 Several of the Office XP programs give users the ability to protect file content by setting a password. You can configure a policy setting that disables this feature by turning off the command bar buttons and menu bar items that are used to... KB#309312. Keywords: Microsoft Access, Password, Templates

 
40. Sample Macro to Import Data with More Than 256 Fields or Columns Microsoft Excel spreadsheets have 256 columns (column IV). Therefore, Excel cannot accept data with more than 256 fields per record on a worksheet. When you attempt to manually import data from a database or text file that has more than 256 fields... KB#272729. Keywords: Import Data, Format, Errors, Macro, VBA, File Name, Text Files, Web

 
41. How to call a Visual Basic .NET Class Library from Visual Basic for Applications in Microsoft Office Use this step-by-step guide to call a .NET class library from Visual Basic for Applications. This sample shows how a Visual Basic for Applications program can use a Visual Basic .NET class library to encrypt and decrypt a string. You can use... KB#317535. Keywords: DLL, Arrays, Class, VBA, Macro, Web

 
42. You may receive "The command you selected is not available from this shortcut" error message when you use the Open dialog box or the Save dialog box in Excel 2003 When you use the Open dialog box or the Save dialog box in Microsoft Office Excel 2003, you may receive the following error message: The command you selected is not available from this shortcut. You may receive this error message even if you are... KB#834681. Keywords: Add-In, DDE, Third-Party, Errors, Error Message, Registry

 
43. How to Use ADO to Return Data to a ListBox or ComboBox In Microsoft Excel, you can use the ActiveX Data Objects (ADO) library in a Visual Basic for Applications macro to work with a SQL database. This article contains a sample macro that returns the results of your query to a ComboBox control or a... KB#244761. Keywords: Query, ActiveX, SQL, Combo Box, VBA, Macro, Object, UserForm, Web

 
44. How to Mark an Automation AddIn Function as Volatile This article contains sample Microsoft Visual Basic for Applications code that demonstrates how to mark an Excel Automation Add-In function as... KB#278328. Keywords: Add-In, ActiveX, DLL, Class, VBA, Object, Web

 
45. How to Reduce the Chances of Macro Virus Infection This article explains how you can reduce the risk of infecting Microsoft Excel -- including your worksheets, templates, and add-ins -- with macro... KB#269613. Keywords: Third-Party, Password, Macro, VBA

 
46. How to Minimize Metadata in Microsoft Office Documents Whenever you create, open, or save a document in any of the programs listed at the beginning of this article, the document may contain information that you may not want to share with others if you distribute the document electronically.... KB#223396. Keywords: OLE, Printing, Files

 
47. How to Use DAO in Excel Without Referencing DAO Library In Microsoft Excel, if you attempt to use data access objects (DAO) without first referencing the Microsoft DAO 3.0 or 3.5 Object Library, you may receive an error message. This can cause difficulties when you are developing applications... KB#152400. Keywords: DAO, OLE, Errors, VBA, Object, Error Message, Toolbar, Web

 
48. How to use an Excel Data Source for Mail Merge in Word 2000 This article explains three ways to attach a Microsoft Excel data source to a Microsoft Word mail-merge main document. After you perform step 1 in the Mail Merge Helper, use one of the following methods in step 2 in the Mail Merge Helper to attach... KB#212314. Keywords: DDE, Files

 
49. How to Drag Data from Microsoft Excel to a Microsoft Access Database This article shows you how to use the drag-and-drop method to copy data from a Microsoft Excel worksheet to a table in a Microsoft Access... KB#208640. Keywords: Microsoft Access

 
50. How to Use Microsoft Excel Data Source for Word Mail Merge This article describes three methods to attach a Microsoft Excel data source to a Word mail merge main... KB#155179. Keywords: DDE, Files

 

<< (Page 3)  Previous              Next  (Page 2) >>