Find Jobs
Hire Freelancers

Access Update Query for cleaning Table

$25-50 USD / hour

已关闭
已发布将近 6 年前

$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: 17447032

关于此项目

39提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
39威客以平均价$35 USD/小时来参与此工作竞价
用户头像
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 在40天之内
4.9 (328条评论)
7.9
7.9
用户头像
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 在40天之内
5.0 (66条评论)
7.4
7.4
用户头像
Hi! May I see the file? Few records will be sufficient. Regards, Branislav MIhaljev
$41 USD 在40天之内
5.0 (256条评论)
7.5
7.5
用户头像
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 在20天之内
4.9 (189条评论)
6.9
6.9
用户头像
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 在40天之内
4.9 (110条评论)
7.2
7.2
用户头像
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 在20天之内
4.7 (90条评论)
7.3
7.3
用户头像
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 在1天之内
4.8 (106条评论)
6.8
6.8
用户头像
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 在2天之内
4.9 (170条评论)
6.6
6.6
用户头像
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 在2天之内
4.8 (202条评论)
6.4
6.4
用户头像
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 在40天之内
5.0 (54条评论)
6.0
6.0
用户头像
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 在40天之内
4.8 (99条评论)
5.9
5.9
用户头像
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 在40天之内
4.6 (55条评论)
6.2
6.2
用户头像
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 在40天之内
4.8 (74条评论)
6.0
6.0
用户头像
I have excellent command on MS Access and Excel VBA. I can fix the issue with the hidden characters.
$25 USD 在2天之内
4.9 (90条评论)
6.0
6.0
用户头像
Hi there, Could you please share the excel and access file? Looking forward to hear from you. Regards
$25 USD 在4天之内
5.0 (9条评论)
5.3
5.3
用户头像
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 在10天之内
4.8 (32条评论)
5.3
5.3
用户头像
Hi i am vba developer...expertised in web scraping & vba macros.... i can scrape any website either static or dynamic also thankyou
$25 USD 在40天之内
4.9 (38条评论)
4.5
4.5
用户头像
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 在40天之内
5.0 (1条评论)
3.7
3.7
用户头像
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 在30天之内
5.0 (2条评论)
1.9
1.9
用户头像
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 在10天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Brooklyn, United States
5.0
16
付款方式已验证
会员自3月 1, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。