I am trying to import a text file into Access and the only delimiter is the ~ symbol. I am using version 2010. In the wizard I can put the ~ in for a text separator but not for a field separator. I know that I have done this in the past because I ave received the same file format from the same source and managed to get it imported but now I can't seem to get it to work. Anyone know how to do this? I really don't want to have to open the file in Excel or do any other type of pre-processing because I am writing the application for someone else and don't want to complicate it.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.