> Doesn't ADO provide a driver for CSV files like it does for Access? I
> thought ADO could access CSV, TAB, txt, and Excel files, as well as
> Access files, and even run queries against a CSV file just like it can
> against an Access table. I've never needed to do this, but I always
> thought that I would try it if I ever needed to access CSV/TAB files
> from within my ASP code. Anybody know if this can be done?
TXT_CONNECTIONSTRING = "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=" & ServerPath & ";" & _
"Extensions=asc,csv,tab,txt;" & _
"Persist Security Info=False"
Set Conn = CreateObject("ADODB.Connection")
Conn.Open TXT_CONNECTIONSTRING
' OPEN TEXT FILE AS A DB
sql = "SELECT * from EVENTS.TXT;"
set rs = conn.execute(sql)
'Insert code to opend Access db and insert records here
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
