• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

Word - Access

Hello All
I have a .dat file that when opened in M/S Word, Notepad or WordPad doesn't recognize the carriage returns. There is a title "~" at the end of each row. I would like to do a edit/replace with a carriage return.
 
Also can i do it thru code?
I want to open it in ms Acc2010 thru code and process line by line.
Thanks in advance
0
frimy
Asked:
frimy
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
press Ctrl-H for the Find/Replace dialog box in Word

search: ~
replace: ^p

this can be done programmitically as well but it is just a simple Replace in each file.  How many files are there?
0
 
frimyAuthor Commented:
Crystal,

It works fine.
I have those files constantly.
How can do it programmatically?
Thanks
0
 
GrahamSkanRetiredCommented:
frimy,
See my comments in  your duplicate question:
https://www.experts-exchange.com/questions/28976506/Word-Access.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now