Find Jobs
Hire Freelancers

Access Update Query for cleaning Table

$25-50 USD / hour

Closed
Posted almost 6 years ago

$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.
Project ID: 17447032

About the project

39 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
39 freelancers are bidding on average $35 USD/hour for this job
User Avatar
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 in 40 days
4.9 (328 reviews)
7.9
7.9
User Avatar
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 in 40 days
5.0 (66 reviews)
7.4
7.4
User Avatar
Hi! May I see the file? Few records will be sufficient. Regards, Branislav MIhaljev
$41 USD in 40 days
5.0 (256 reviews)
7.5
7.5
User Avatar
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 in 20 days
4.9 (189 reviews)
6.9
6.9
User Avatar
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 in 40 days
4.9 (110 reviews)
7.2
7.2
User Avatar
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 in 20 days
4.7 (90 reviews)
7.3
7.3
User Avatar
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 in 1 day
4.8 (106 reviews)
6.8
6.8
User Avatar
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 in 2 days
4.9 (170 reviews)
6.6
6.6
User Avatar
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 in 2 days
4.8 (202 reviews)
6.4
6.4
User Avatar
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 in 40 days
5.0 (54 reviews)
6.0
6.0
User Avatar
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 in 40 days
4.8 (99 reviews)
5.9
5.9
User Avatar
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 in 40 days
4.6 (55 reviews)
6.2
6.2
User Avatar
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 in 40 days
4.8 (74 reviews)
6.0
6.0
User Avatar
I have excellent command on MS Access and Excel VBA. I can fix the issue with the hidden characters.
$25 USD in 2 days
4.9 (90 reviews)
6.0
6.0
User Avatar
Hi there, Could you please share the excel and access file? Looking forward to hear from you. Regards
$25 USD in 4 days
5.0 (9 reviews)
5.3
5.3
User Avatar
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 in 10 days
4.8 (32 reviews)
5.3
5.3
User Avatar
Hi i am vba developer...expertised in web scraping & vba macros.... i can scrape any website either static or dynamic also thankyou
$25 USD in 40 days
4.9 (38 reviews)
4.5
4.5
User Avatar
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 in 40 days
5.0 (1 review)
3.7
3.7
User Avatar
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 in 30 days
5.0 (2 reviews)
1.9
1.9
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Brooklyn, United States
5.0
16
Payment method verified
Member since Mar 1, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.