G
Guest
I have a proc that updates a table with users who have missed training. Some
users miss more than one course, so my code concatenates the course strings
so I only have 1 record in my table per user, and it does so in a way that is
like using Alt+Enter to separate text while in a table field.
Works fine until I dump the data to Excel via another proc. The course info
comes out in one line instead of each course on a separate line (not a
separate cell, but a separate line within the same cell). These courses look
right in my table, with each course on a separate line within the same field.
I’ve tried different combinations of vbCrLf, vbCr, etc., but it still ends
up in Excel without the formatting. These characters are replaced with little
boxes. Of course, if I manually go into the cell and do the Alt+Enter, I can
separate the info, but I want this done automatically.
I don’t know if this is something I can do in Access when I send data to my
table or if it is something I have to do in my Excel code when dumping to a
sheet. I would prefer to take care of in Access.
Any suggestions?
users miss more than one course, so my code concatenates the course strings
so I only have 1 record in my table per user, and it does so in a way that is
like using Alt+Enter to separate text while in a table field.
Works fine until I dump the data to Excel via another proc. The course info
comes out in one line instead of each course on a separate line (not a
separate cell, but a separate line within the same cell). These courses look
right in my table, with each course on a separate line within the same field.
I’ve tried different combinations of vbCrLf, vbCr, etc., but it still ends
up in Excel without the formatting. These characters are replaced with little
boxes. Of course, if I manually go into the cell and do the Alt+Enter, I can
separate the info, but I want this done automatically.
I don’t know if this is something I can do in Access when I send data to my
table or if it is something I have to do in my Excel code when dumping to a
sheet. I would prefer to take care of in Access.
Any suggestions?