"Roman Kuzmin" <z@z.z> wrote in message
news:uJGAXE0AHHA.4992@TK2MSFTNGP03.phx.gbl...
> Try this:
>
> $objConnection.Open('Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\temp;Extended Properties="text;HDR=YES;FMT=Delimited"')
>
> --
> Thanks,
> Roman
as an addition to Roman's anwer
I have some more information and examples about opening and using textfiles
with ADO (and also for using it with other providers like SQL Excel )on my
blog :
that can help you getting started with this
CSV :
http://mow001.blogspot.com/2006/03/w...-part-one.html http://mow001.blogspot.com/2006/03/w...-part-two.html
Fixed Lenght :
http://mow001.blogspot.com/2006/07/w...881469178.html
Greetings /\/\o\/\/