To source data from an Excel file, you must define a name for the range of data being sourced:
Then you can perform with the help of ODBC - Open Database Connectivity a sql statement as :
select Id, Name from Employee
You can manage the existing name with the Name Manager.
In Microsoft 2007 > Tab Formulas > Name Manager
insert into [Sheet1$] (id,name) values(5,'Nico')