The native SQL will (more or less be) the SQL of Microsoft Access. To specify an unnamed range of cells as your recordsource, append standard Excel row/column notation to the end of the sheet name in the square brackets. The table name of a worksheet is the name of the worksheet with a dollar sign ("$") appended to it, and surrounded with square brackets ("") of a range, it is simply the name of the range. Once connected to an Excel workbook, a worksheet or range is the equivalent of a table or view. Look for them when setting up a connection (such as with the Data Connection Wizard). Following along the "get Excel data via SQL track", here are some pointers.Įxcel has the "Data Connection Wizard" which allows you to import or link from another data source or even within the very same Excel file.Īs part of Microsoft Office (and OS's) are two providers of interest: the old "", and the latest "". There are many fine ways to get this done, which others have already suggestioned.
0 kommentar(er)
