从考勤机读取文本文件 [英] reading text file from attendance machine

问题描述

我有一台考勤机可以通过IP获取数据，并将其作为文本文件存储在PC中。现在我想要一个简单的应用程序（尽可能简单），我可以在其中输入员工详细信息，可以创建一些报告。

我想在MS Access中这样做。我在访问中也创建了一些表（员工表，考勤表）。但如何连接文本文件和如何读取文本文件？



希望我能理解。如果有人可以帮助我，那将是值得欣赏的。我不想要确切的解决方案，但是解决问题的方法。





提前致谢

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

推荐答案

使用Access连接文本文件不会有用 - 您需要提供代码来读取文本文件，将其分解为数据的组并将其转移到行中访问表的基础信息。



可能最简单的方法是不首先使用文本文件 - 将数据直接传输到数据库而不是你t双重处理只能引入复杂性和错误的数据。



我们无法告诉您如何处理文本文件 - 我们没有无论它包含什么，或者它是如何组织的 - 所以你将不得不查看你的数据并找出相关的信息！

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!

这篇关于从考勤机读取文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！