Menu ID list of SAP B1

The following table lists the business objects that are exposed through the DI API.
Object Name Object ID Description

ID		Name
257		&About SAP Business One
272		&Help
275		&Context Help    F1
276		H&elp Settings
512		&File
514		&Close
518		&Page Setup
519		P&rint Preview
520		Pr&int    Ctrl+P
523		&Launch Application
524		Loc&k Screen
526		Exi&t Ctrl+Q
768		&Edit
769		&Undo Ctrl+Z
770		&Redo Ctrl+Shift+Z
771		&Cut Ctrl+X
772		C&opy Ctrl+C
773		&Paste Ctrl+V
774		&Delete Del
775		&Select All
1024		&Window
1025		&Cascade
1026		C&lose All
1029		M&essages/Alert Overview
1030		&Main Menu Ctrl+0
1280		&Data
1281		&Find Ctrl+F
1282		&Add Ctrl+A
1283		&Remove
1284		&Cancel
1285		R&estore
1286		Cl&ose
1287		&Duplicate Ctrl+D

Read Excel using SQL

Excel reading is possible only if system is installed with AccessDatabaseEngine(32 or 64bit), and below configuration is done in SQL;

Step 1 : Re-Configure the SQL settings for reading Excel.

 sp_configure 'show advanced options', 1;
 GO
 RECONFIGURE;
 GO
 sp_configure 'Ad Hoc Distributed Queries', 1;
 GO
 RECONFIGURE;
 GO

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO


Step 2 : Reading Excel

Excel must be inside any of the Drive folder with full permission of system having SQL Installed.

Execute the below query; Were excel is in D:\ExcelUpload folder

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=D:\ExcelUpload\YourExccelName.xlsx', 'select * from [Sheet1$]')