Import text document with code

[heidihutton]

Want to have a stardard text file that is imported when a button within a form is clicked. I have the standard text file. It is CURRENT.TXT
Users will replace the current text file every couple of weeks and then hit a button to import the new data to an existing table.
(Old data has been deleted)

How can I do this with code?

Thanks for any help.

 

[FancyPrairie]

The following code is how you read a text file

Dim intInputLUN as Integer
Dim strRec as string

intInputLUN = FreeFile
Open "CURRENT.TXT" For Input As #intInputLUN

Do Until (EOF(intInputLUN))

Line Input #intInputLUN, strRec

Loop