Type search words and press enter
Check your pre-qualified business loan offer in TallyCapital with a single click! Based on your financial data, get a tentative offer and apply for a business loan in TallyPrime!
https://help.tallysolutions.com/docs/td9rel54/td9/faq/import_csv_files_using_odbc.htm

Is it possible to import data from csv files using ODBC?

Yes, it is possible to import data from csv files using ODBC.

Syntax

ODBC: "Driver=Microsoft Access Text Driver (*.txt, *.csv); Dbq=<Complete Path without File Name>; Extensions=asc,csv,tab,txt;"

Example

[Collection : Ledger SRCCollection]

ODBC   : "Driver=Microsoft Access Text Driver (.txt,.csv);Dbq=C:\CSVImport\;Extensions=asc,csv,tab,txt;"
SQL    : "Select * from SampleData.csv"