brewpedals
Registered User.
- Local time
- Today, 11:12
- Joined
- Oct 16, 2002
- Messages
- 32
I am using MSAccess97.
I have a dB in production that is collecting status reports into a memo field from a form control.
I need to export this data to a comma delimited file to import into another platform. The memo field is full of "double quotes"
and they are corrupting the data by inserting the data beteen the "s in the next adjacent field.
My VBA skills are limited to cut paste and edit.
Do any of you have a method of either
1. stripping the memo of the double quote marks
-or-
2. validating control input.
-or-
3. stripping the offending character from the input.
Many Thanks
I have a dB in production that is collecting status reports into a memo field from a form control.
I need to export this data to a comma delimited file to import into another platform. The memo field is full of "double quotes"
and they are corrupting the data by inserting the data beteen the "s in the next adjacent field.My VBA skills are limited to cut paste and edit.
Do any of you have a method of either
1. stripping the memo of the double quote marks
-or-
2. validating control input.
-or-
3. stripping the offending character from the input.
Many Thanks
