Lately I have been receiving excel files with the address cell containing one address, a carriage return and another address. I need to export these excel files into access. Is there some way to remove this carriage return from excel before exporting or to remove them from access after...
My computer has recently been upgraded to Access 2000. I work with numerous Access databases. Many of these databases are made by importing data from Excel. Reps and dealers email these Excel files. They are in various versions of Excel and have unknown formats. I am finding that with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.