Hallo everyone!
I spent a lot of time today searching for a response to my question but
I had unfortunately no success.
The problem is the following:
I have got an Access-table called Employee with an ID and one
corresponding Field/Column called comment. These comments are stupidly
multi-line (separated by a Return).
It's my aim to have access (he he, wordplay) to these two fields in
Excel whereas the field shouldn't be longer that 255 characters.
I considered three solutions:
The table could be changed after being exported to excel in the
following two ways:
- Multiple Comment Columns could be created and then be filled by an
automatism which splits the one Column according to the CR-Signs.
- A new Worksheet could be used to contain n lines for each Employee
whereas n is in accordance with the number of lines of the original
multi-line column comment.
Something like
ID Comment
10 a long comment\newline\more text
Would result in:
ID Comment
10 a long comment
10 more text
The second solution would be the best due to the further handling of
the data.
Another solution would be programming something like this directly in
Access. Sadly, I have nearly no skills neither in programming access
nor in programming something like that in Excel.
I would be so delighted if someone could help me!
Regards,
Julian
PS: Excuse me for my "German English"
Bookmarks