DSN-less text driver connection?? 
Author Message
 DSN-less text driver connection??

Is there a way to connect to a text file without using a DSN?

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Mon, 21 Apr 2003 03:01:25 GMT  
 DSN-less text driver connection??
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
                   "Dbq=\mypath\;" & _
                   "Extensions=asc,csv,tab,txt;" & _
                   "Persist Security Info=False"

Filename has to be specified in the SQL statement :

Rs.Open "Select * From customer.csv", _
               Conn, adOpenStatic, adLockReadOnly, adCmdText

Quote:

>Is there a way to connect to a text file without using a DSN?

>Sent via Deja.com http://www.deja.com/
>Before you buy.



Mon, 21 Apr 2003 03:33:05 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DSN-less text driver connection??

2. Crystal and ODBC DSN/DSN-less connections - do I need USER DSN or SYSTEM DSN

3. Import Excel with ODBC Drivers and DSN-less connection

4. DSN less connection to server error IM012 Driver keyword syntax error

5. Need DSN'less connection to Client Access ODBC Driver

6. VB 6.0 DSN less connection to a text file

7. DSN-less connection for a text file.

8. VB 6.0 DSN less connection to a text file

9. performance different between DSN to DSN-Less Connection

10. DSN vs DSN-less connections

11. Need Connection string for VB6 DAO DSN-LESS Connections to SQL Server 2000

12. Connection string for DSN-less Informix connection

 

 
Powered by phpBB® Forum Software