Re: Strange Results when Reading a TXT File Using Database Technologies

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank You!! The Schema.ini is working great!!

Thx,
Scott Buerkley



On Wed, 28 Sep 2005 18:46:48 -0700, "Michael Harris \(MVP\)" <mikhar
at mvps dot org> wrote:

>Scott wrote:
>> I am getting strange results when reading a comma delimited txt file
>> using database technologies. It gets the records from a file and
>> displays PN. Sometimes it returns the part number correclty and
>> sometimes it comes back empty with the same code and just changing the
>> data in the text file it is reading.
>>
>> Overall, if there are more PN's that have letters and numbers in it
>> then both alphanumeric and number only PN's work. If there are more
>> numeric numbers then only the numeric numbers get returned correclty
>> and the alphanumeric come back empty.
>>
>> What can I do so it will aways work wither it is alphanumeric or
>> numeric only?
>
>Don't depend on ADO to infer field data types by sniffing the data. Use an
>explicit schema.ini file instead...
>
>Much ADO About Text Files (Scripting Clinic)
>http://msdn.microsoft.com/library/en-us/dnclinic/html/scripting03092004.asp?frame=true
>
>ado csv schema.ini group:microsoft.* - Google Groups
>http://groups.google.com/groups?q=ado%20csv%20schema.ini%20group:microsoft.*
>
>
>
>--
>Michael Harris
>Microsoft MVP Scripting
>
>
>
>

--
The Source For Premium Newsgroup Access
Great Speed, Great Retention
1 GB/Day for only $8.95
.