I am attempting to import a comma delimited file into MS Access. I have ticked the delimited & comma boxes where appropriate when importing the file. However in the source file there are fields where there is a comma inbetween some of the words in the fields. How can I write a query to remove the comma (,)inbetween words within a field?
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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing text files into MS Access
- Thread starter taboo
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question