>>Hi,
>>
>>I have searched on the web but could not find the answer to the following question.
>>
>>When importing data from CSV file via ODBC, the driver is using SCHEMA.INI by default. I was wondering if, when calling SQLSTRINGCONNECT() or SQLEXE(), it is possible to specify a different INI name than default SCHEMA.INI?
>>
>>Thank you.
>___
>Dmitry,
>
>(
http://www.connectionstrings.com/?carrier=textfile )
>
http://msdn.microsoft.com/en-us/library/ms709353.aspx>
>(1) Different ini file - I do not think so
>(2) However, - see first paragraph of link - it says it's in the same directory of the text data source. So I think you can replace the contents - or use different directories each with their own schema.ini
Gregory,
Primero, muchas gracias por tu ayuda.
I have tons of files to convert so placing them into different directories would be a major PITA. I will have to just convert one at a time and rename schema.ini to something like myfile1_schema.ini, myfile2_schema,ini, etc. So that if I need to go back and redo some, I can rename them.
De nuevo, thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham