A
atse
Hi,
I tried to make select query to a text file using the code below,
<%
sconnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="D:\myforlder\;Extended Properties=""text;HDR=No;FMT=Delimited"""
set conn2=server.CreateObject("ADODB.Connection")
conn2.open(sconnection)
set dRs=conn2.execute("select * from test.txt")
%>
But it complaints that:
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/thisfile.asp, line 7 (set dRs=conn2.execute("select * from test.txt"))
Any errors have I made? But if the file is test.csv, it works fine.
But the way, where can I find more samples of query string of all kinds of
database connection?
Thanks
Atse
I tried to make select query to a text file using the code below,
<%
sconnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="D:\myforlder\;Extended Properties=""text;HDR=No;FMT=Delimited"""
set conn2=server.CreateObject("ADODB.Connection")
conn2.open(sconnection)
set dRs=conn2.execute("select * from test.txt")
%>
But it complaints that:
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/thisfile.asp, line 7 (set dRs=conn2.execute("select * from test.txt"))
Any errors have I made? But if the file is test.csv, it works fine.
But the way, where can I find more samples of query string of all kinds of
database connection?
Thanks
Atse