How to build an Excel server template with MS SQL Server as external data

Part 1 Create 2 tables in pubs of SQL Server

Part 2 build  MS SQL server external data

Part 3 Build a Excel Server template

1.Define single fields.

2.Define multiple fields.

Part 4 fill the test1 in My workbench

Part 5 fill the test1 in ESWeb

Part 6 see the data in MS SQL Server 2000