<div>
&gt;Is there a workAround or should my files avoid dots ?<br />
if found that problem also already, and you have indeed to avoid the dots.
</div>


>Is there a workAround or should my files avoid dots ?
if found that problem also already, and you have indeed to avoid the dots.

<div>
<br />
i don't know if this is linked to the fact Db objects are normally called by [DBNAME].[Owner].[object] but i am trying to see if there is another way but with files containing dots (automatically generated so...)...<br />
<br />
i'll let the question open a week to see if someone found a workaround or not <br />
<br />
(i found nowhere anyone presenting this problem so at least it will offer the opportunity for people having it to stop looking as mad)
</div>



i don't know if this is linked to the fact Db objects are normally called by [DBNAME].[Owner].[object] but i am trying to see if there is another way but with files containing dots (automatically generated so...)...

i'll let the question open a week to see if someone found a workaround or not

(i found nowhere anyone presenting this problem so at least it will offer the opportunity for people having it to stop looking as mad)

<div>
More a work around than a solution
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to read a csv file using ADO.<br />
<br />
when my filename is like toto.csv it works fine.<br />
<br />
When i set it to to.to.csv it failed...<br />
<br />
Does someone have an info on this ?<br />
Is there a workAround or should my files avoid dots ?<br />
<br />
<br />
conString Provider=Microsoft.Jet.OLE<wbr />DB.4.0;Dat<wbr />a Source=S:\CSV\;Extended Properties='text;HDR=YES;F<wbr />MT=Delimit<wbr />ed'<br />
query : select * from _Lst.login.csv<br />
<br />
Thanks a lot
</div>
</div>


Hello,

I am trying to read a csv file using ADO.

when my filename is like toto.csv it works fine.

When i set it to to.to.csv it failed...

Does someone have an info on this ?
Is there a workAround or should my files avoid dots ?


conString Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:\CSV\;Extended Properties='text;HDR=YES;FMT=Delimited'
query : select * from _Lst.login.csv

Thanks a lot

ADO CSV: read file where file name contains &quot;.&quot; impossible ?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

ADO CSV: read file where file name contains &quot;.&quot; impossible ?

ADO CSV: read file where file name contains "." impossible ?