Text Support

[Works]

Hi all,
What type text format that MS ACcess support?
I had copy/paste from MS Word, FileMaker Pro and DOS into MS Access Memo field. They act very strange. Is it t a way to copy these text out to some othher format to script them to MS Access supported format and paste them back into MS Access?

Thanks,

Works

 

[The_Doc_Man]

DOS? {gasp}{choke}{cough} Did he really say DOS?

OK, here is the simplest I can give you.

1. DOS itself ought not to give you a headache but FileMaker for DOS might.
2. MS Word might or might not give you a headache, depending on whether any format control stuff is hidden in the copy/paste string.

See, Access is NOT a word-processing program. It knows zip about format control embedded in text streams. Whereas MS Word and FileMaker Pro use embedded control sequences quite a lot. If it happens that you capture some of those sequences, Access will not know what to do with them. So it treats them as ordinary (if ugly) characters and displays them - if possible.

Access via COPY/PASTE supports ONLY raw text such as is created by Notepad - .TXT or maybe .CSV files. And .LOG maybe.

Access via one of the IMPORT wizards will support a lot more formats. But not via COPY/PASTE. Only through whole-file import operations.

 

[Works]

DOS? {gasp}{choke}{cough}
Yes Sir.
Unlucky that I still have some very important text with that format.
So, I can export them out save as under .tex, .csv, adn .log format and then inport them back to Access. Should that work?

Thanks for your input again,

Works

 

[The_Doc_Man]

If you can export to .TXT or .CSV, that is a format Access can import very easily.

Be aware that if your text includes commas as a legit part of a single text field, you might need to enclose the text fields in quotes. OR use some other delimiter than comma as a field marker.

Sorry I'm slow to respond. My home ISP and I are going round-and-round about some things and I've been on vacation so my ability to post from the office has been moot for at least a week.