Capital Gain Excel Import → Syntax Error

Income Tax || Capital Gain Excel Import → Syntax Error

      

Root Cause of the Error →
The error occurs when a client enters a special character (') in the Capital Gain Excel template.

      

Solution →
  1. Open the Capital Gain Excel template intended for import into the software.
  2. Identify and remove any instances of the special character (') from the data within the Excel sheet.
  3. After correcting the data in Excel, re-import the template into the software.
      

By following these steps, you can ensure that the data entered in the Excel sheet is imported successfully.


    • Related Articles

    • Income Tax || Import capital gain data via KDK Excel template

      Step 1: Navigate to the Transaction section and select "Capital Gain". Step 2: Choose the special Excel sheet made for Capital Gain from the options. Step 3: Fill in all the info about your capital gains into the Excel sheet. Step 4: Click the button ...

    • Income Tax || Export and Import Capital Gain Data via Zerodha Excel Template

      Steps to Export and Import Capital Gain Data via Zerodha Excel Template Exporting Capital Gain (Tax P&L) Data from Zerodha Step 1: Access the Tax P&L Section Log in to your Zerodha account. Click on the Reports tab. Step 2: Select Tax P&L Choose the ...

    • Income Tax || Data Feeding - Capital Gain

      What is Capital Gains Tax in India: Capital Gains Tax is a tax on the profit or gain that an individual or a business entity earns from the sale of capital assets. The capital assets can include property, stocks, bonds, gold, or any other asset. The ...

    • Zen IT || Excel Import → Type Mismatch, Error in excel import

      Root Cause of the Error: The error stems from either erroneous data entry in the Excel sheet or alterations to the format of the specific Excel file. Solution → Validate Date Format: Verify that dates adhere strictly to the format "dd/MM/yyyy". ...

    • Income Tax || You have an error in your SQL syntax

      [MySQL][ODBC 3.51 Driver][mysqld-4.0.13]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAD"',0)' at line 1 Error in cmdOK_Click Solution: Please note that this ...