Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import tilde (~) .txt file into Access Using Import Wizard
Duane, The Wizard screen gives me 3 variables to set First Row Contains Field Names (Y/N) Choose the delimiter that separates your fields: Tab/Semicolon/Comma/Space/Other Text Qualifier ("/'/{none}) The "Other" option under fields appears to allow a person to enter a symbol here but won't...- EKaufmann
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Import tilde (~) .txt file into Access Using Import Wizard
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...- EKaufmann
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
