Shulou(Shulou.com)06/02 Report--

This article mainly introduces "what problems should be paid attention to by ADO retrieval editors". In the daily operation, I believe many people have doubts about what problems ADO retrieval editors should pay attention to. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "what problems should be paid attention to by ADO retrieval editors"! Next, please follow the editor to study!

Note: the tests in this article were performed using Microsoft Data Access Components (MDAC) 2.5 on Microsoft Windows 2000 with Visual Basic 6.0 Service Pack 3 and Excel 2000. This article may not confirm or discuss different phenomena that users may observe when using different versions of MDAC, Microsoft Windows, Visual Basic, or Excel.

Connect to ExcelADO using ADO you can connect to the Excel data file using either of the following two ADO searches in MDAC. Microsoft Jet OLE DB Provider-or Microsoft OLE DB Provider for ODBC Drivers how to use the Microsoft Jet OLE DB ProviderJet provider requires only two pieces of information to connect to the Excel data source: the path (including the file name), and the Excel file version.

Excel version: for Excel 95 workbooks (Excel version 7.0), specify Excel 5.0; for Excel 97, Excel 2000, or Excel 2002 (XP) workbooks (Excel versions 8.0,9.0 and 10.0), specify Excel version 8.0.

If a Jet provider that uses the data Link Properties dialog box uses the ADO data Control or data Environment in the application, the data link properties dialog box appears to collect the necessary connection settings. If a Jet provider that uses the data Link Properties dialog box uses ADO Retrieval Control or data Environment in the application, the data Link Properties dialog box appears to collect the necessary connection settings. On the providers tab, select the Jet 4.0provider; the Jet 3.51provider does not support Jet ISAM drivers. If the Jet 3.51 provider is specified, the following error message appears at run time:

On the connections tab, browse to your workbook file. Ignore the user ID and password entries because they do not apply to Excel connections. Cannot open a password-protected Excel file as a data source. More information on this topic is available later in this article.

On all tabs, select the extended attribute from the list, and then click Edit value. Enter ADO retrieval to separate it from any other existing items with a semicolon (;). If you omit this step, an error message will appear when testing the connection because the Jet provider expects the Microsoft Access database if not specified otherwise. Return to the connections tab and click Test connection. A message box appears informing you that the test has completed successfully. Other Jet provider connection Settings

At this point, the study of "what problems should be paid attention to by ADO retrieval editors" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.