Find Jobs
Hire Freelancers

Create an Access 2010 Import Project

$30-40 USD

进行中
已发布超过 11 年前

$30-40 USD

货到付款
I need a Access application created with one form which will do an import based on my specs. I need it in 2 days. Has to be done in Access 2010 no exceptions. Form has 2 controls - a listbox with filenames imported. - Button to import file - Dialog so user can browse files. - Textbox to show file [login to view URL] can overwrite it. ## Deliverables Allow user to browse and select file. Use Parseit as an example. Filename with path shows in textbox. Click OK button to import file. Before import check if Filename exists in table FilesImported. If yes then ask user if he wants to import the file. Delete all records in table ProdAllocated. Import records into ProdAllocated. Read through lines of Parseit Line 1 ProductCode for line 1 = Code1 Rating = 111 taken from the first line "XXXXXXXXXXXXXXXX111B" Quantity = 20. Line 9 ProductCode for line 9 = Code3 Rating = 334 taken from the first line "XXXXXXXXXXXXXXXX334B" Quantity = 30. If Product Code/Rating not in ProdAllocated then add record. If Product Code/Rating is in ProdAllocated then update Quantity. After Import is complete Add a new record to the table FilesImported - Filename (File imported) - ImportDate (is the date the file imported) - Datestamp ( string of date + time) - User = "GUSER" When import is done there should be 4 records in table ProdAllocated ProductCode Quantity Rating Code1 80 111 Code2 40 222 Code3 20 333 Code3 50 334
项目 ID: 2777063

关于此项目

3提案
远程项目
活跃12 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$34 USD 在2天之内
4.9 (44条评论)
5.6
5.6
3威客以平均价$32 USD来参与此工作竞价
用户头像
See private message.
$32.30 USD 在2天之内
5.0 (43条评论)
4.8
4.8
用户头像
See private message.
$30.60 USD 在2天之内
5.0 (14条评论)
3.9
3.9

关于客户

CANADA的国旗
Guelphu, Canada
5.0
108
付款方式已验证
会员自11月 18, 2011起

客户认证

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