rahmathk

 Profile Answers by rahmathk Questions by rahmathk

• Mar 14th, 2007

 

Hi,

  Create a DSN for excel.
  Create a .xls file with multiple tab and name each tab.
  Use db_connect and db_excute function to access multiple tab's.
  Table name should be mentioned in square brackets with$ sign.
  
sample code

qry="select * from[Emp$]";
dsn="DSN=excel;DBQ=E:\W_RUN\test.xls";
rc=db_connect("query1",dsn,30);
rc=db_execute_query("query1",qry,record_number);