How to write schema.ini and why am I using Schema.ini in the folder of text file.

Hello All,

Trying to connect a text file as a database and query since I have 2.6 million records of data in a text file.

I understood that I should maintain schema.ini file in the folder which contains text files. I am unable to write the data in schema.ini nor understand what data to include and what format in the schema.ini.

Any help is highly appreciated.

0
edit delete
are you sure?
asked Amol Pawar

1 answer

Hello,

to connect text file you don't have to use schema.ini, but then use standard connection string:

"Driver={Microsoft Text Driver (.txt;.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;" (https://www.connectionstrings.com/textfile/).

For identification fileds name i always use sql querry: "SELECT * FROM [Your_file.txt]", then i loop for fields name - VBA exemple :

Sub TestFile

Dim RS as Object,CNN as String,SQL_Q as String,i as IntergerCNN="Driver={Microsoft Text Driver (*.txt;*.csv)};Dbq=c:\txtFilesFolder \;Extensions=asc,csv,tab,txt;"
SQL_Q="SELECT * FROM [Your_file.txt]"
Set RS=CreateObject("ADODB.RecordSet")
RS.Open SQL_Q,CNN,2,4For i=1 to RS.Fields.count step 1
    Debug.Print RS.Fields(i-1).Name  // or diffrent place to print fields.name
Next i
RS.CloseSet RS=Nothing

End Sub

If this dosent work create schema.ini in this folder by create new text file. In this file write:

[Your_file.txt]

Format=Delimited(;)

save and close file than change file extension to .ini. Delimited says what kind of separator is used in [Your_file.txt]

0
edit delete
are you sure?
answered Krysztof Spaliński

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions

This page is the archive of this page:https://www.connectionstrings.com/questions/54241/how-to-write-schema-ini-and-why-am-i-using-schema-ini-in-the-folder-of-text-file/, the copyright belongs to the original page!
aspxhtmlmobile0898kendouidemosaspxhtml docs