Import a text file

[Gary Eck]

I need to import/append multiple files from 1 folder into 1 table in Access. All the files have the same last word.ex.051703-Reconcile. Can anyone help?

G

 

[WayneRyan]

Gary,

You need VBA code on a Command Button.

FileName = Dir("C:\*.Reconcile")
While FileName <> ""
   DoCmd.TransferText  FileName <-- Just Guessing on the syntax
   FileName = Dir()
   Wend

hope that gets you started,
Wayne