Hi guys, I'm hoping that someone here may have needed to accomplish what I need to do and have already written a solution, because I have already done some net searches for this an can only find an Excel solution that doesn't port over to Access VBA.
I have some data that is being imported from Excel into Access, and everything I need to have working does, except that there are unrecognized characters being imported into the Access fields (like carriage returns). I have noticed that Excel has a Clean function, it would be possible for me to use, as I already have some Automation going on between Access and Excel, but I'm wondering what would be the best ay to get rid of non-printable characters?
I have some data that is being imported from Excel into Access, and everything I need to have working does, except that there are unrecognized characters being imported into the Access fields (like carriage returns). I have noticed that Excel has a Clean function, it would be possible for me to use, as I already have some Automation going on between Access and Excel, but I'm wondering what would be the best ay to get rid of non-printable characters?