How to Query Excel
Select * from [empdata$];
You need 2 things.
1 - Sheet Name (In above case "empdata")
2 - bracket the sheet name and "$" after the sheet name.
See here for other cross platform SQL Examples
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Search This Blog
Keyword Index
- _Rollback_ tables (1)
- _SRC Schema Builder (1)
- _SRC Schema Builder Error (1)
- .NET version (2)
- “Is Numeric” Switch (1)
- 106 Pack (1)
- 107 Pack (1)
- 108 Pack (1)
- 109 Pack (1)
- 110 Pack (1)
- 110 Pack Fix (1)
- 111 Pack (1)
- 112 Pack (1)
- 113 Pack (1)
- 114 Pack (1)
- 115 Pack (1)
- 116 Pack (1)
- 117 Pack (1)
- 120 Pack (1)
- 121 Pack (1)
- 122 Pack (1)
- 123 Pack (1)
- 124 Pack (1)
- 125 Pack (1)
- 126 Pack (2)
- 126 pack issue (1)
- 127 Pack (1)
- 300 Pack (1)
- 301 Pack (1)
- 302 Pack (1)
- 303 Pack (1)
- 304 Pack (1)
- 311 Pack (1)
- 312 Pack (1)
- 313 Pack (1)
- 314 Pack (1)
- 315 Pack (1)
- 316 Pack (1)
- 317 Pack (1)
- 318 Pack (1)
- 319 Pack (1)
- 320 Pack (1)
- 320 Pack Patch (1)
- 321 Pack (1)
- 322 Pack (1)
- 323 Pack (1)
- 324 Pack (1)
- 325 Pack (1)
- 64 Bit (1)
- access (1)
- Advanced Settings (2)
- AgentBatchSeqFailAll Setting (1)
- ALTER TABLE statement conflict (1)
- Alternating Row Shading (1)
- Apostrophe (1)
- Array auto value population (1)
- ASVersion (3)
- Audit (1)
- authentication (1)
- Auto dim failure - p_ETL_CR_DIM_FILES (1)
- Auto Dim feed (1)
- Automated Dimension (2)
- Batch (1)
- Batch Run Sequence (1)
- BatchSeqOverride (1)
- Best Practices (1)
- BPC MS (1)
- BPM Connect (72)
- BPMC (71)
- BPMC Connect (1)
- BPMC Data Process Control Error (1)
- BPMC FAIL (1)
- BPMC Metabase (1)
- BPMC notification capability (1)
- BPMC Software and system access requirements (1)
- BPMC_IFramework (3)
- BPMC_MbrGen.exe (2)
- Bug: Injection Wizard does not copy over ETL Engine setting correctly (1)
- Bugs (15)
- Cancel Button (1)
- Cancel Button Missing (1)
- Cannot find table 0 (3)
- Carriage Return Issue (1)
- Cell Search (1)
- Change Instance Name in Config Builder (1)
- Change Tracking (1)
- Checkpoint (1)
- Chrome (1)
- Cntrl+R (1)
- Cntrl+S (1)
- Columns To Row (1)
- Commands (1)
- Compression (1)
- Config Builder 2.0 Hotfix (1)
- Config Builder 2.2.5 (1)
- Config Builder 2.2.7 (1)
- Config Builder 3.0.1 (1)
- Config Table Backup (1)
- ConfigBuilder Bug: Code in feeds auto changes across instances (1)
- Configuration Error (1)
- Configuration Grid Flicker Issue (1)
- Container Creation Bug (1)
- Container Feed Failure (1)
- Container Hotfix (1)
- Container Process Fail (1)
- Cross Browser (1)
- CTOR (2)
- Cube Process after Dimension/Master Data Feed (1)
- Currency Capability (1)
- Currency Conversion Issue (1)
- Daisy Chain (4)
- Daisy Chain Optimize (1)
- Data Loss Prevention Prompt (1)
- Data Map (3)
- Data Map Datatype Definition (1)
- Data Map Optimize (1)
- Data Map Optimize Enhancement (1)
- Data Map SELECT INTO [] error (1)
- Data Map SQL Missing (1)
- Data Map SQL Tab Blank (1)
- Data Map SQL Tab does work (1)
- Data Process Control (4)
- Data Process Ribbon (1)
- Data Requester - Microsoft OLE DB Provider for SQL Server Desc (1)
- DataGridPost - System.Data Desc: Cannot find column (1)
- DataGridPost - System.Data Desc: Cannot find column 6 (1)
- dbo.p_ETL_MAP error; too many arguments specified (1)
- DBObjects (2)
- Delete Process Error (1)
- Detailed logging switch (1)
- Dimension Automation (3)
- Dimension Automation Error (1)
- Dimension vs. Measure vs. Natural (1)
- DMAP (1)
- DPC (6)
- DPC Application Pooling (1)
- DPC Best Practice (1)
- DPC Error (2)
- DPC Look and Feel (1)
- DPC Ribbon (1)
- DPCInstance setting (1)
- DPCLinkIconOnly (1)
- DPCRefreshInterval (1)
- drop down lists (1)
- dstlookup (1)
- DTS (5)
- DTS Working Directory (1)
- DTSX (2)
- Dynamic Queue Capability (1)
- DynamicQueue_Threshhold Setting (1)
- Email alert settings (1)
- EPM client (1)
- EPM Settings (1)
- Error Deleting Processes (1)
- ETL Engine 3.2.1 (1)
- ETL Engine 3.x Sync Solution (1)
- ETL_ table auto remove (1)
- Excel (1)
- Excel Add-in (1)
- Excel DataGrid Issues (1)
- Execute Feed (1)
- Execution Point (1)
- External Process Tab (1)
- External Processes (2)
- FAIL (1)
- Failed to obtain column collation information (1)
- Failed! Incorrect syntax near keyword 'into' (1)
- FdMgr.BuildAgentJob (1)
- FdMgr.BuildAgentJob Error (1)
- FDMgr.Schedule_Save (1)
- FEED (1)
- Feed Rename Error (1)
- Feed runs in zero Seconds (1)
- Feed success but no cube process (1)
- Feeds collide across multiple BPMC instances (1)
- Feeds run in zero (0) seconds successfully (1)
- Feeds will not Cancel (1)
- FIELD_NOT_VALID (1)
- Filter Tab Issue (1)
- Firefox (1)
- firstpass (1)
- Global Configurations (5)
- Gross Margin Percent Calc (1)
- Handy feature (1)
- Handy SQL (4)
- Hang Checker (1)
- Hide Feeds (1)
- High-performance BPC MS Integration to SAP (1)
- hot key (1)
- Hot Keys (1)
- Hotfix (2)
- how to configure BPM Connect to process dimensions in a BPC (1)
- How to execute feed in DTS mode via command line (1)
- How to execute feed in SSIS mode via command line (1)
- Hyper-link Fix (1)
- IE 11 (1)
- IE 11 Support (1)
- IE10 (1)
- IIS6 Management Compatibility (1)
- Indented sub task detail (1)
- Index Performance Problem (1)
- Injection Observations (2)
- Injection Wizard (1)
- Instance Variable (1)
- InstanceConfig.xml (2)
- Internet Explorer 10 (1)
- Internet Explorer 11 Support (1)
- Internet Explorer Settings (1)
- Invalid object name (1)
- Invalid URI (1)
- Job BPMC_ONDEMAND_BROKER was deleted while it was executing: the outcome was (Unknown). (1)
- Job failed on Analysis Services processing (1)
- Job failed on data synchronize (1)
- Job failed on kickouts (1)
- Jobs Cancel (1)
- KB2858725 (1)
- KB2894854v2 (1)
- Keyword Search (1)
- Keywords (1)
- Keywords auto value population (1)
- Kick-out Exclusions (1)
- Kick-out Performance Boost (1)
- Kickout Error Solution (1)
- Kickout report bug (1)
- Kickout Zero Suppress Solution (1)
- Kickouts (1)
- Kickouts Zero Suppression (1)
- Language and Regional Settings (1)
- Last run time (1)
- Legacy Data Map Functionality Bug (1)
- Lines Vanishing in Data Pipeline (1)
- lists (1)
- load data panel (1)
- Load Panel Warning (1)
- Login failed for user ETL (1)
- Login Failure for user (1)
- Makedim (1)
- MakeDim Task Error (1)
- Manifest (1)
- mapsource (1)
- MbrSheet (1)
- me (2)
- Membersheet Generator (3)
- Membersheet Interop (1)
- meta tag page refresh (1)
- MetaBase Backup (1)
- Metabase Backup Fails;Invalid object name BPMConnect..CONST_SYS (1)
- MethodControlActive Key (1)
- misbehaved (4)
- Missing Members from Kickout Report (1)
- msmdpump capability (1)
- Notification Redundant Keys (1)
- Notifiction Hyperlink (1)
- NULLs (2)
- Nulls in Signeddata (1)
- odbc (1)
- Optimize (1)
- Optimize Capability in Data Map (1)
- ORACLE Packge (1)
- p_ETL_CR_DIM_FILES (1)
- p_ETL_CUR (2)
- p_ETL_RQP (1)
- p_ETL_RQRS (1)
- p_log_step failure (1)
- p_UI_ISBATCHRUN (4)
- p_UI_LOADPANEL Error (1)
- p_UI_STAT (1)
- Pack Version Check (1)
- Packs (8)
- Parameter auto value population (1)
- Parameter button missing from container (1)
- Parameter Display Order in the Load Panel (1)
- Parameter Dropdowns dont display in schedule panel (1)
- Parameters (1)
- passx (1)
- Patent (1)
- pending (1)
- Performance Tune Feeds (2)
- Play animations in Webpages (1)
- Please Confirm ASVersion (1)
- POSTDEPLOY (1)
- PREDEPLOY (1)
- priorpass (1)
- Problem Linking Up to Instance (1)
- Process was not renamed error (1)
- proxy (2)
- RegCreateKeyEx() returned error 5 (1)
- Remote Stage Timeout (1)
- RenderDataGrid Error on Schedule Panel (1)
- requirements (1)
- reserved words (1)
- RFC Connector Error (1)
- RFC Enablement (1)
- RFC Select Statement (1)
- RFC Trace error log (1)
- RFC Troubleshoot (1)
- Ribbon (1)
- Roles (1)
- Row (1)
- Rows to Columns (1)
- RQRS table (1)
- RTOC (2)
- RTOC Error (1)
- RTOC Fixed Header Capability (1)
- schedule (1)
- Schedule Panel Error (1)
- Schedule Panel Issue (1)
- Scheduled Jobs do not Run (1)
- Scrolling (1)
- Search and Replace (2)
- Search and Replace function not working (1)
- Search Next (1)
- Sequential Batch Processing (1)
- Server Error in '/BPMC_Services08' Application (1)
- Settings (1)
- Signeddata (1)
- SISS (1)
- Slow running Data Map (1)
- Snap Panel Icons (1)
- Software (1)
- Solution (1)
- Sort (1)
- Sort Final Result Column (1)
- SQL (6)
- SQL error (1)
- SQL Error on DBObjects script (1)
- SQL Server 2005 (1)
- SQL Server 2008 (3)
- SQL Server 2008 R2 Bug (1)
- SQL Server 2012 (1)
- SQL Server 2014 (2)
- SQL Server 2014 R2 (1)
- SQL Server 2014 Support (1)
- SQL Sever 2012 (1)
- SQL Sever 2014 (1)
- SQL08 (2)
- SQLISPackage100 (1)
- SQLISPackage100 Error (1)
- SQLISPackage100 errors (1)
- SSIS (4)
- SSIS ETL Engine Kill and Fill Issue (1)
- SSIS ETL Engine Version Check (1)
- SSIS Package Tricks (1)
- SSIS package version error (1)
- SSIS Sync Bug (1)
- Status Meter Frozen (1)
- Surface Area (1)
- Surface Area Advanced Settings (2)
- Surface Area error (1)
- Sync With Zero Balance Safety Fixed (1)
- synch mode (1)
- Synchronize (2)
- Syntax (1)
- system (1)
- System.Data.SqlClient.SqlException (1)
- System.NullReferenceException (1)
- table 0 not found (1)
- Table Schema Version (1)
- Text Driver (1)
- text file load (1)
- The hostname could not be parsed (1)
- The metadata could not be determined (1)
- The script returned a failure result (1)
- The type initializer for 'SAP.Middleware.Connector.RfcDestinationManager' threw an exception (1)
- There was a problem. Process is not Deleted (1)
- This grid cannot be saved. Roll back in process (1)
- This page has misbehaved (1)
- Timeout (1)
- Tip (5)
- Transformation (4)
- Transport (1)
- Tuning (4)
- Usability (1)
- Usage Roles (1)
- Use of Special Characters; Job Failed on Kickouts member index build; Period in Name (1)
- User rights assigment disappear from feed (1)
- vanish (1)
- Variable auto value population (1)
- Variables (2)
- version (6)
- Visual Pipeline (1)
- Web Services (1)
- What pack is installed? (1)
- Windows Update (1)
- Zero Balance Safety Bug (1)
No comments:
Post a Comment