please help me on excell import , I want sheet name default possition first Sheet , plese sugest experts advance thanks to all [Collection : ExPurchase Import Excel] ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + @@XLTotFilePath SQL : "Select * from [Sheet1$]" i don't want fix the sheet name, i want first sheet name defualt
In TDL (Tally Definition Language), when importing from Excel using ODBC, the sheet name must be explicitly mentioned in the SQL query (e.g., [Sheet1$]). Unfortunately, ODBC for Excel does not natively support dynamic selection of the "first sheet" unless the sheet name is known or fetched externally. So in Excel that Sheet you need must always have the name "Sheet1" OR you can use VBScript or Powershell. Before Tally runs the import, a small external script (VBScript or Powershell) can: Open the Excel file. Get the name of the first worksheet. Save it to a text file or pass it to TDL using a System Variable. Use that in the TDL ODBC string.
