[AccessD] Losing order when importing text

On 24 Jun 2003 at 22:52, MartyConnelly wrote:

> Quickest way for user to delete or append to table TempName is something 
> like this.
> Choose an applicable field name in place of DirName.
> 
> If MsgBox("Do you want to create a new file table (yes: create, no: 
> append)", vbYesNo) = vbYes Then
>     DoCmd.RunSQL "DELETE DISTINCTROW TempName.DirName FROM TempName;"
> End If
> 

I keep it even simpler:
DoCmd.RunSQL "Delete * from Tempname"


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.