Clean up data that has been exported out of Access

H

HondoCutty

After exporting data to Excel from access there is a single ` at the
beginning of the record and small square boxes behind every string of
characters that is created using the
“& Chr$(13) & Chr$(10) &†command.

Is there way to remove these, either prior to export in Access or after in
Excel?

Job Site Address: [Job Name] & Chr$(13) & Chr$(10) & [Address] & Chr$(13) &
Chr$(10) & [City] & ", " & [State] & “." & [Zip/Postal Code]
 
J

JL

The "'" is for Excel to indicate that it is a text string. THe small square
is indicate new line. So, it is doing the right thing.
 
K

Ken Snell [MVP]

If you want a carriage return (new line) in the EXCEL cell, don't use
Chr(13) & Chr(10). Just use Chr(10).

EXCEL uses just the Chr(10) character for a new line in the cell.

It's not possible to prevent the inclusion of the beginning ' in the text
strings' export, but you could use Automation and open the EXCEL file when
exported to delete them; however, that ' character is interpreted by EXCEL
and not part of the data. So you should be able to ignore it.
 
Top