Find Jobs
Hire Freelancers

Access Update Query for cleaning Table

$25-50 USD / hour

Cerrado
Publicado hace casi 6 años

$25-50 USD / hour

We have an Access DB that generates a table off a linked excel web linked table. When creating a new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried numerous remove replace queries without success.
ID del proyecto: 17447032

Información sobre el proyecto

39 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
39 freelancers están ofertando un promedio de $35 USD /hora por este trabajo
Avatar del usuario
Hi there, Warm Greetings We came along with your request for Access Update Query for cleaning Table and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Database Programming, Excel, Microsoft Access, SQL, Visual Basic We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$50 USD en 40 días
4,9 (328 comentarios)
7,9
7,9
Avatar del usuario
Hi,joe222! It look like some coding issue, i propose to create python or vba script that will clean them before export. I work with data processing for last 7 years and sure i can help you with this tasks. Regards, Vlad
$41 USD en 40 días
5,0 (66 comentarios)
7,4
7,4
Avatar del usuario
Hi! May I see the file? Few records will be sufficient. Regards, Branislav MIhaljev
$41 USD en 40 días
5,0 (256 comentarios)
7,5
7,5
Avatar del usuario
Please guide what does "?" mean in the data.. Is it some foreign language data or "?" is occurring due to some invalid data ? Looking forward to have a chat with you to discuss further so that i could write a query to sort out this invalid stuff.
$33 USD en 20 días
4,9 (189 comentarios)
6,9
6,9
Avatar del usuario
Hi there,I am Miljan,Access expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$27 USD en 40 días
4,9 (110 comentarios)
7,2
7,2
Avatar del usuario
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Could you send me your Access file ? I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$27 USD en 20 días
4,7 (90 comentarios)
7,3
7,3
Avatar del usuario
Sure. I have good skills in this fields. So I can hlep you if you want. hope to work with you. Than you.
$41 USD en 1 día
4,8 (106 comentarios)
6,8
6,8
Avatar del usuario
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$41 USD en 2 días
4,9 (170 comentarios)
6,6
6,6
Avatar del usuario
Hi, Being experienced in working on several MS access projects, I can help you with query cleanup issue which you facing. Waiting for your response for further discussion in detail. thanks
$25 USD en 2 días
4,8 (202 comentarios)
6,4
6,4
Avatar del usuario
I am a Microsoft Certified excel professional. I understood your problem with the special characters. I have some questions to you as that I would help me to see if I can solve this issue.
$38 USD en 40 días
5,0 (54 comentarios)
6,0
6,0
Avatar del usuario
Hello. I have good skills in Acess, Excel, VBA. I have read your project description and i can do it. Contact me please. Thanks.........................................................
$41 USD en 40 días
4,8 (99 comentarios)
5,9
5,9
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. I do what it takes. Thank you for your consideration. Zura
$27 USD en 40 días
4,6 (55 comentarios)
6,2
6,2
Avatar del usuario
Hi, I am an excel expert and have completed many similar projects before. I suggest you to use excel power query to clean the data before importing to access db. I can help you doing this. please contact me in chat to discuss more. thanks
$41 USD en 40 días
4,8 (74 comentarios)
6,0
6,0
Avatar del usuario
I have excellent command on MS Access and Excel VBA. I can fix the issue with the hidden characters.
$25 USD en 2 días
4,9 (90 comentarios)
6,0
6,0
Avatar del usuario
Hi there, Could you please share the excel and access file? Looking forward to hear from you. Regards
$25 USD en 4 días
5,0 (9 comentarios)
5,3
5,3
Avatar del usuario
Hi, I am a professional MS Access and SQL database developer with 5 years of corporate experience. I can create a function to clean up your all data fileds. Before opening the query the function will find those and clean from all fields. Let me know if you wish to proceed.
$25 USD en 10 días
4,8 (32 comentarios)
5,3
5,3
Avatar del usuario
Hi i am vba developer...expertised in web scraping & vba macros.... i can scrape any website either static or dynamic also thankyou
$25 USD en 40 días
4,9 (38 comentarios)
4,5
4,5
Avatar del usuario
Hello, I can help you in sortout your issue about a query value to clean this up...as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina
$37 USD en 40 días
5,0 (1 comentario)
3,7
3,7
Avatar del usuario
Dear Sir, I have been in this industry for 8 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 1 five start ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kinds of projects. As per your requirement I will do these jobs and will work with good quality of work. What I understood from your problem is that tables’ records or tables are having some whitespace like ? And you want to remove it from the access database. Yes I can help you for that, it could be some whitespace character which can be replaced with blank space but first of all we need to find it and I will do it. We can also try by checking it using some ANSI character. I can help you in 1 hour to fix your issues. If you will give me a chance, I promise you that my work will always make you happy with excellent keys. Thanks, Maulik
$25 USD en 30 días
5,0 (2 comentarios)
1,9
1,9
Avatar del usuario
Hello: I´m really interested in this project, I`m Industrial engineering and I have been working for 10 year in database, Excel, visual basic programming an Power BI. Could you tell me more about the project? Please let me know if you are interested in my profile.
$38 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Brooklyn, United States
5,0
16
Forma de pago verificada
Miembro desde mar 1, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.