I am trying to import a text file, I have tried everything possible, or I think; 24 hours later I have to call on some advice. I have the following code. It is pulling from a comma separated flat text file and inserting it into an access database. I am wanting to combine the two fields which as FName and LName wanting to place it together into a field in access call employees. I was importing into two fields and then doing the work each time I accessed the data. However, it would be easier to import the fields into one the original time and leave it. I have placed the code I thought would work at the very bottom. Why will that code not work? Any suggestions. As you can see from other post, I tried stripping the commas, but then I end of with a value after the last records that will blow the import out with an error on the last record. I wish I could solve that, but this option may be faster. Thanks again.