Hello all,
I have an access database where I import data from an excel sheet to a column. The access column is a long text datatype. The excel sheet cells have multiple "Shift + Enter" which cause the following string to be appended '_x000d_'.
Can some write a query which would replace "Shift + Enter" to simply "Enter" or any other way to correct this issue.
Hello!
I am ready to carry out your project.
You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f
From the Microsoft Access, of course, familiar.
Regards,
Vladimir
I am expert in Access and Excel with 10+ years of experience , I can resolve this issue and can write a query which would replace "Shift + Enter" to simply "Enter" or any other way to correct this issue , kindly consider me and share out the data
Hi,
Me a database expert with special abilities in query handling.
Please provide data exvel and access database to do work and finish it out in any possible way.
Regards
Hi, I can complete this task. Can you send me your excel sheet for better understanding.
I've experienced on working with databases such as MSacess, MYSQL and MongoDB.
Let’s discuss on chat.
Thanks
Bhavnesh
Hello,
I can resolve quickly.
You can send an example file excel or already imported into Access to create a query that makes the correction.
If you send it now, in the next hour, the question has already been resolved.
Kind regards
Hello,
I just saw your project and would like to offer you my services on this. From your statement the issue is not very clear but it seems to be easy for me. Because I have good experience with MS Office. Kindly provide further info or give a sample file so we can move further.
Expecting a prompt reply from your side.
Regards,
Moeez
Hello,
In MsAccess:
UPDATE ImportedExcelTable SET MyField = Replace( MyField,Chr(10),Chr(13) & Chr(10));
or in CSV excel
Use Find and Replace _x000d_
If you need help I can assit you.
Best regards