Σε Εξέλιξη

MS Access VBA Code import csv. log files in table

I have some files (one for each month) which I want to use in a MS Access DB.

Information:

- The csv file is a log file with entries every 5 minutes

- each month a new csv file is created, name: [yyyy_mm].csv

- The files needs to be imported on button click (manually) into one access table

- csv file has a timestamp (can be used as ID) and each column in csv file has a corresponding column in access table

- samples of csv files and Database will be provided

- for Use in MS Access 2016 and Windows 10

- no Use of separate files

To-Do:

On Button click:

- lookup last entry in access table (e.g. by using timestamp)

- check if csv file has new entries (=rows)

- if yes, only values of NEW entries need to be added to access table

- on month change, last month entries also need to be added to table first

- identify corresponding columns by name (not by order). If csv file has more or non corresponding columns, display msgbox

- change number format: csv is formatted english (decimal separator is "."), access is formatted german (decimal separator is ",")

- if a value in csv file is "NULL", import value in access needs to be "0"

Δεξιότητες: Microsoft Access, Visual Basic για Εφαρμογές

Δείτε περισσότερα: Erstellen eines Pflichtenhefts, erstellen eines online stores, access vba code open table, import csv file access vba, import excel file access vba code, import large csv file access vba, vb net code csv import access, import excel access vba code, access vba code read ole object, csv import access, asp csv import access, import access vba, access vba code file via ftp, csv import access vbnet, vb6 csv import access, convert access vba code vbnet, processor access vba code, flash games converter softwares, database softwares, softwares taurusweb, softwares needed develop net application, bluetooth softwares, softwares increase youtube videos, search crack softwares, yellow pages softwares

Σχετικά με τον Εργοδότη:
( 3 αξιολογήσεις ) Leinfelden-Echterdingen, Germany

ID Εργασίας: #12782613

Ανατέθηκε στον/στην:

draco77

Hey there, From the sounds of it, you need an Access expert who can write VBA Code to import csv log files into table. Is that sounds about right? I have an extensive knowledge of Access included VBA. I have also a Περισσότερα

€25 EUR σε 1 μέρα
(1 Αξιολόγηση)
1.0

23 freelancers κάνουν προσφορές με μέσο όρο €42 γι' αυτή τη δουλειά

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Περισσότερα

€100 EUR σε 3 μέρες
(69 Αξιολογήσεις)
6.1
mail2vimalarora

Hi.. I have gone through your project details and comfortable to take it forward. pls reply to discuss further.

€34 EUR σε 6 μέρες
(74 Αξιολογήσεις)
5.7
zu02

Hi there, if you'd really like to have a professional Ms Access software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background deve Περισσότερα

€111 EUR σε 1 μέρα
(29 Αξιολογήσεις)
5.8
alaeddindhahri

Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I ha Περισσότερα

€90 EUR σε 2 μέρες
(10 Αξιολογήσεις)
4.2
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Περισσότερα

€61 EUR σε 1 μέρα
(11 Αξιολογήσεις)
4.4
VladimirLilenko

Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Περισσότερα

€30 EUR σε 1 μέρα
(17 Αξιολογήσεις)
3.9
AlexandrUKR

please send the csv file, i can send first draft for your test within few hours .

€30 EUR σε 1 μέρα
(4 Αξιολογήσεις)
3.7
€40 EUR σε 1 μέρα
(2 Αξιολογήσεις)
3.1
jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens Περισσότερα

€30 EUR σε 2 μέρες
(7 Αξιολογήσεις)
3.4
gr8tech

I have knowledge of MS Access and VBA. I will be able provide the solution as requested to upload the CSV into an access database with the conditions as stated. PM for more discussions on your requirements

€29 EUR σε 3 μέρες
(13 Αξιολογήσεις)
2.7
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Περισσότερα

€30 EUR σε 1 μέρα
(5 Αξιολογήσεις)
2.5
rafeemd

I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.

€30 EUR σε 1 μέρα
(1 Αξιολόγηση)
2.0
nurnga1218

I just finished Access macro database few weeks ago. You can see my review to proof it. For your project I think will can be done in 2 or 3 days. Hope we will discuss further. Thanks.

€19 EUR σε 3 μέρες
(2 Αξιολογήσεις)
1.5
ahmedtaher2020

A proposal has not yet been provided

€26 EUR σε 2 μέρες
(1 Αξιολόγηση)
0.5
ghsoftlab

Hi, I'm an electronic and computer engineer with expert knowledge of database development, Microsoft Access, SQL and VBA programming. I have experience in working with csv files. I reviewed specification You gave a Περισσότερα

€20 EUR σε 5 μέρες
(1 Αξιολόγηση)
0.1
ryeleussinov

Dear Client, I appreciate your time spent consideration of my cover letter below. Let me kindly express my interest in your current project. Please review my online profile here and LinkedIn profile for more det Περισσότερα

€24 EUR σε 30 μέρες
(0 Αξιολογήσεις)
0.0
chugoleng

Good Day, I am writing with reference to your posted job for want of a MS Access Developer. I consider that my credentials and interests match with your requirement and want to propose for the same. Looking for Περισσότερα

€21 EUR σε 1 μέρα
(0 Αξιολογήσεις)
0.0
sinisacurcin

More then 20 years of experience in programming and databases. I graduated in Computer Science and Electrical Engineering (University of Belgrade, School of Electrical Engineering). Excellent knowledge and experienc Περισσότερα

€34 EUR σε 1 μέρα
(0 Αξιολογήσεις)
0.0
€111 EUR σε 1 μέρα
(0 Αξιολογήσεις)
0.0
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well Περισσότερα

€23 EUR σε 1 μέρα
(0 Αξιολογήσεις)
0.0