No problem Dan, actually here is something else really cool you might want to try if your users generally have a set number of files they need to import (say three):<br><b><br> Dim Message, Default As String<br> Dim MyValue1, MyValue2, MyValue3 As String<br> Dim Title<br> Message = "Enter the file name and path." 'Set Prompt<br> Default = ""<br> MyValue1 = InputBox(Message, Title, Default) <br> MyValue2 = InputBox(Message, Title, Default)<br> MyValue3 = InputBox(Message, Title, Default)<br> DoCmd.TransferText acImportFixed, "YourSpecName", "YourTableName", MyValue1<br> DoCmd.TransferText acImportFixed, "YourSpecName", "YourTableName", MyValue2<br> DoCmd.TransferText acImportFixed, "YourSpecName", "YourTableName", MyValue3<br></b><br><br>tihs way they can put them all in, and then walk away while they are waiting. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>