Færdiggjort

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.

Evner: Databehandling, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Zurich, Switzerland

Projekt ID: #17738949

Tildelt til:

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 på 1 dag
(7 bedømmelser)
4.3

7 freelancere byder i gennemsnit $36 på dette job

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 Flere

$50 USD på 1 dag
(70 bedømmelser)
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 Flere

$30 USD in 2 dage
(40 bedømmelser)
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 Flere

$54 USD på 1 dag
(51 bedømmelser)
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 Flere

$30 USD på 1 dag
(33 bedømmelser)
5.5
rinabuoy13

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

$30 USD på 1 dag
(49 bedømmelser)
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.

$30 USD på 1 dag
(31 bedømmelser)
4.0