reading text file from attendance machine

Question

0.00/5 (No votes)

See more:

I have an attendance machine from where I can fetch data via IP and it stored in a PC as text file. Now I want a simple application (as simple as possible) where I can enter the employee details, can create some reports.
I was thinking to do that in MS Access. I have created some tables as well (employee table, attendance table) in access. but how to connect the text file with access and how to read the text file?

Hope I can make understand. If somebody can help me, that would be appreciate. I don't want the exact solution, but the way to solution the problem.

Thanks in advance

Posted 13-May-15 20:41pm

Member 11689494

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-05-13T20:57:00

Connecting a text file with Access is not going to do anything useful - you need to provides code to read the text file, break it into it's "groups" of data and transfer those into row based information for Access tables.

Probably the easiest way is not to use a text file in the first place - transfer the data directly into a DB instead and you aren't "double handling" the data which can only ever introduce complications and errors.

We can't tell you what to do with the text file exactly - we have no idea whatsoever what it contains, or how it is organised - so you are going to have to look at your data and work out out to extract the relevant info!