QUERY PROBLEM

[gsc123]

sConn = "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & "DefaultDir=" & "C:\Inetpub\

http://wwwroot\parse"

& ";Extensions=asc,csv,tab,txt"

I have the above connection to a csv file,,, my update query is this

update ESCORTLIST set ESCORTLIST.Title = '1997-1998 FORD ESCORT AIR BAG MODULE.' where ESCORTLIST.id = 1

The error is

[Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'ESCORTLIST.txt'. Make sure the object exists and that you spell its name and the path name correctly.


...any ideas?

This is my execute code?

rs2.Open sConn
rs2.Execute(sql)

 

[snowboardr]

I am curious as to why you would be working with a txt file?? I don't see this a very efficient... why dont you use MySQL database? You wouldn't have any trouble like you are having now.

Jason

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]

 

[BigRed1212]

Maybe try:

Dim sConn, sql, rs

sConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\path_to_ESCORTLIST.txt\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""

sql= "update ESCORTLIST set ESCORTLIST.Title = '1997-1998 FORD ESCORT AIR BAG MODULE.' where ESCORTLIST.id = 1"

rs.Open sConn
rs.Execute(sql)

I'm not good at connection strings, though, so this probably won't work.

 

[gsc123]

Tried all that, i'm using the access to work with

 

[snowboardr]

MySQL is better.

http://vzio.com/tutorials/mysql_database.asp

Jason

[red]Army[/red] : [white]Combat Engineer[/white] : [blue]21B[/blue]

 

[Sheco]

I believe the text driver is read only.

 

[Sheco]

The good news is you can use the FileSystemObject to edit text files.

 

[gsc123]

on to different servers now though SQL

 

[tsuji]

Update" or "delete from" is not supported. But I think "insert into" is.

 

[gsc123]

I see, thxs for that