MS Access VBA Code import csv. log files in table
€8-30 EUR
货到付款
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"
项目ID： #12782613
关于项目
有22名威客正在参与此工作的竞标，均价€42/小时
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 更多
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 更多
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 更多
Hi.. I have gone through your project details and comfortable to take it forward. pls reply to discuss further.
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 更多
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
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.
i am a lead .Net software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Access.
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.
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 更多
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 更多
