I wonder if someone can help with with an issue regarding exporting data from Access to Excel?
I'm trying to export some data, and on the whole everything is going OK. The only problem I am having is that in some instances the data appears in the wrong location.
I've cheched some of the instances, and in each case it seems to be that some of the data is on a new line (in these instances, the content which is on the new line in Access, appears in a new row (first column) in Excel)
I've tried using the following to replace any line breaks:
var_string = replace(var_string, "\n", "<br />")
var_string = replace(var_string, "vbLf", "<br />")
var_string = replace(var_string, "vbCrLf", "<br />")
var_string = replace(var_string, "vbCr", "<br />")
... and although that has resolved the issue in some cases, there are still a few instances where content is appearing on the wrong line.
I've also tried using the appropriate chr() attributes, but I get the same results.
Does anyone have any ideas?