Use ADO in Access to Query an Excel Spreadsheet скачать в хорошем качестве

Use ADO in Access to Query an Excel Spreadsheet

Query an Excel Spreadsheet like a database table **The code listing for this video can be found at: http://accessjitsu.com/2015/09/13/cod... In this video we will discuss using ADO (Active-X Data Objects) to connect to an Excel spreadsheet and then to retrieve data from the spreadsheet, returning a recordset. This can provide a convenient method of access to data in your spreadsheets. Using ADO, you can execute a query against a worksheet, selecting a subset of columns or rows. We will use the returned data to update an Access table. *Note: I forgot to mention in the video that you need to set a reference to Microsoft Active-X Data Objects under Tools and References (in the code window). All of my videos organized by topic and other blog topics: http://accessjitsu.com/ Other videos in this series: Setup Access to Link to/Import from Excel Spreadsheets    • Setup Access to Link to/Import from Excel ...   Import an Excel worksheet into Access: TransferSpreadsheet Method    • Import an Excel worksheet into Access:  Tr...