databasename.tablename.export ("c:\temp.txt")

Any help of this would be much appriciated.

Thanks in advance

oh ya, im using vb5 on access database

Open the database with a standard ADO connection and then add:

Dim cmd as object
Set CMD = CreateObject("ADODB.Command")
cmd.activeConnection = cn  '-- the connection object
cmd.commandType =  1  'which is the same thing as adcmdtext
cmd.CommandText = "SELECT * Into [text;hdr=yes;database=C:\][nameoffile.txt]
From [tablename]"
cmd.Execute

hth