Access DB - SIG Macro

Hello! I am ready to carry out your project in the reasonable price and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

NOTE : I HAVE EXPERTISE IN VBA AND EXCEL MACROS. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed few projects which involved Programming, scripting and excel. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards

I looked at your existing macro in some detail and I’m not surprised it is slow. Free tip: it pauses on each row for 1 second just to display progress. For a 60,000 row full that would cost 17 minutes of wasted time. Just comment out the wait for a great improvement in speed. I think the problem could be solved in Access with a query based on a cartesian join between the log table and the subnet table. It would do all the maths inside the SQL query which would be very efficient. However I cannot predict how big a dataset it could manage: 10,000 rows certainly, 100,000 probably, 1 million maybe. It could be done in batches, if necessary. I would love to tackle this problem – it’s got under my skin! However my standard rate is £65GBP / $85USD / $120AUD per hour and I think it would take a day to make all the changes required. I have over 20 years experience developing applications in Access, Excel, Word and Outlook and I’m highly skilled with SQL and VBA. I have clients in countries all over the world, including the USA, Canada, Europe and Australia, . We interact via email, telephone and TeamViewer. . My morning is your evening but I work flexible hours if we need to talk. Please call me without obligation on +44 292 125 8848 to discuss your project further. I am generally available from 09:00 to 18:00 BST / 16:00 to 01:00 AWST / 18:00 to 03:00 AEST. Or message me with more detail or if you have questions. Kind regards Neil Sargent

Hi there, Gone through your requirement of migration of excel database to Access database. Have done lot of projects related to this. Kindly go through my profile and and reviews and come back for the chat to discuss more. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Regards, Karthick G.

There are major optimization technique in access / excel vba have to follow when dealing with large data's. Can you send the file, Let me verify and do the change as per needed. Ram.

Hello, Hope this message finds you well, I checked your details and I believe that my experience is what you are looking 4. I have been working on similar projects for the past eight years, and I have the essential skills including; Data Processing Excel Statistics Statistical Analysis SPSS Statistics I will prove to be of great help to you. SEND MESSAGE/CHAT, so that discuss more on the details including budget and deadlines… Please REMEMBER to; Wash your hands frequently, Maintain social distancing, Avoid touching eyes, nose and mouth..., Practice respiratory hygiene, Stay home and if you feel unwell seek medical care early. Regards, BrainCenter Inc

Hi! I am an Information System Enginner with 14 years of experience. I have done many projects related to Excel Macros and automations, Access Databases. So I have plenty experience in this area. I am new in freelancer.com, so thats why I haven't done many projects, but I do this kind of tasks in my every day job. I made projects with Macros in Excel, that insert, update and select the información from Access Databases. Also Im a Database Expert, so I can help you to perform difficult queries. I would like to help you with this. Thanks.

Good morning, I am Pedro Requena, I am a Business Administrator and Visual Basic Specialist, I was reviewing your need and I have several suggestions: 1 The macro is very overloaded with recorded code, so it is not functional, the code must be relative not recorded. 2 You are working data in a spreadsheet as if it were a database so it takes so many hours to read the data. 3 You can activate the error handling and validation codes that I did not see much in your project. 4 I can help you design a Table in SQL from Firebird 2.5 (free development software) in ISQL, so you can download the data from the selected files and then on your sheet you can make queries and calculations on your database, all by the same price.

Hi, I am ready to convert your excel vba to access vba. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 12 years. Other skills: Access vba, Excel vba, C#, Php, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers. Best Regards. Khaled Alflah

Hi dear sir/madam, I'm very active and interested to work with you. My time is up to you. I have many experiences in this case and you could award your project to me and enjoy it. With best regards

I would suggest a better approach out of expperience. Option 1> try to convert the whole process into ms access database driven process. This means we will use ms access for your data manipulation (searches, ... etc.) and the only one step with excel is to import the data into ms access (which will be done by a click inside the new ms access app) Option 2> as it looks like you are manipulating SIEM data, we can simply use SPLUNK with more efficient results (database with time dimension as a data element Kindly check my updated resume in my profile for more details regarding my experience footprint. That being said, I am looking forward to hear back from you.

I am expert in working MS word, Excel, PowerPoint presentation and data typing work and have been doing this kind of work for last 5 years. I am very confident that i would be able to deliver the project on time with 100% accuracy. I will be very grateful to you if this project awarded to me. Please do let me know if you are interested. Waiting for your quick response. Thank You.

Leave a message and more detail info to work on then I can show you some result in few hours Bring it on... I have been playing with: Data Warehouse | ETL | Business Intelligence | Analytics | Data Insights | Database | Data Modeling | OLAP | ROLAP | MOLAP | Data Mart | SQL Server | SSDE | SSAS | SSIS | SSRS | PBIRS | Visual Studio | Power BI | Report Builder | Mobile Report Builder | Dashboard | KPI | Microsoft Office | Macro | VBA for too long, hope that I can be useful

I used to work as accounting staff here in the Philippines, and I may say that I am suitable for this work because i used to do things such as Data Entry, encoding, Excel, as well as Bank Reconciliation. I am new here at Freelancer but I can guarantee you that I can do my job as you expected, I work fast and efficiently and I am very much dedicated to all the tasks that was given to me. Looking forward to work with you and hope to hear from you soon. Thankyou!

Hey! You can count on me for this one. I have relevant work experience of over 2 years creating and automating macros using VBA. In fact, I use VBA every day at work! Hit me up ! Thanks, Apurva

hi there, i am amr elshenawy iI have more 15 experience in working with excel VBA and MSACCESS I THINK YOU NEED TO TRANSFER THE EXCEL FILE TO ACCESS FILE AND USE THE RULES DEFINED IN EXCEL MODULE TO DESIGN A REPORT IN ACCESS i already import your data in excel to ms access ( data sheet and subnet sheet) and wating for your agreement to complete the work and also are you sure that the excel macro do the result you need and i think you have to send me the rules excatly thank you

Hello there, I read your project description and i am able to do this job. I can do your job as your demand. I will give you unlimited revision before and after the job. I am a new person in this website but honestly I have work experience more than 08 year's in other's online market sir. I am fully prepared to work with you. I have a lot of experience and skills in this job in other online markets. With me you get 100% satisfied in your work. You don't hire me for your satisfaction, just discuss with me once you project, see the demo I gave you and then let me know your decision. Thank you.

Hello I would like to help you in this project. I have 10 yrs experience in ms access programming. regards Akhilesh Sharma