已完成

VBA (Visual Basic for Applications ) Excel/acces

1.) Export a table from Excel to acces

Note: One table contains Project data of one month

2.) The table contains 29 Columns

3.) The unique identifier (UID) consists of 8 columns .

4.) If Project data of the corresponding month exists -> replace the existing record set.

Note: Data exists if "Jahr" &"Monat"&"PSP" match

Ideas exist to enhance the Project.

技能: 数据处理, Excel, 微软Access, Visual Basic, Visual Basic的应用程式

查看更多: visual basic for applications office 2016, vba access, vba examples, visual basic for applications download, vba code, vba script, vba language, vba excel 2016 tutorial, visual basic word excel, web data extraction visual basic code excel, visual basic solidworks excel, visual basic applications excel sorting data, visual basic scripts excel copy data cells, visual basic autocad excel, visual basic update excel data, vba visual basic import, visual basic diff excel files, optimisation visual basic avec excel, visual basic read excel form user, visual basic applications vba macros workbook corrupted

关于此雇主:
( 0个评论 ) Zurich, Switzerland

项目ID: #17738949

授予:

quickapp100

Hi i am software developer from india i did many application for windows and web .. i can create this kind of export import tool can i discuss more about it ? Thanks

$25 USD 在1天内
(7条评论)
4.3

7 威客就此工作平均出价 $36

archanaoswal

I know how to integrate Excel and Access and exchange data between them. I have excellent command on MS Excel and Access. I have completed complex projects in both before . For instance - Built a delivery schedul 更多

$50USD 在1天里
(70条评论)
5.6
expertcoder1vw

Hi, I am an expert Access developer and can do the job for you. This requires developing a macro in Access (via a command button on a form in the database), that when clicked will import the Excel file. The necessar 更多

$30 USD 在2天内
(40条评论)
5.7
zu02

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 更多

$54USD 在1天里
(51条评论)
6.1
dvcontact

Hi, I have read very carefully your project details about wirting VBA codes data will export data from Excel sheet to Microsoft Access and replace existing record set if data exist. I am absolutely sure that I can com 更多

$30USD 在1天里
(33条评论)
5.5
rinabuoy13

Hello Sir, I am experienced excel developer. I can help with the task. Looking to hearing from you, Kind regards

$30USD 在1天里
(49条评论)
5.3
prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.

$30USD 在1天里
(31条评论)
4.0