select for a text file

[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

[Randy Rahbar]

> But the way, where can I find more samples of query string of all kinds of

database connection?

http://www.connectionstrings.com

[TomB]

I assume your connection string is on one line?

sconnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="D:\myforlder\;Extended Properties=""text;HDR=No;FMT=Delimited"""
---------^

what's that for?

"atse" <du******@yahoo.com> wrote in message
news:GH********************@news01.bloor.is.net.ca ble.rogers.com...

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

[atse]

"Randy Rahbar" <rvrahbarAThotmail.com> wrote in message
news:OU**************@tk2msftngp13.phx.gbl...

But the way, where can I find more samples of query string of all kinds of database connection?

http://www.connectionstrings.com

Sorry, I can't find what I want. I want the select string for a text file:

"select [what] from [what] where [what] = [what]"

Because there is no table, or field name in the text file, how can I write
this string. Thanks for any idea.

Atse

[Randy Rahbar]

> Sorry, I can't find what I want. I want the select string for a text file:

"select [what] from [what] where [what] = [what]"

Because there is no table, or field name in the text file, how can I write
this string. Thanks for any idea.

Atse

I'm assuming the first row of your comma-delimited text file are the column
names...

So, if the first column name is Column_ID and the second column name is
Column_Name, I think something like this should work...

SELECT Column_Name FROM yourtextfile.txt WHERE Column_ID = 1
-Randy