Reading text files

  • Thread starter Thread starter Sikiru Olusanya
  • Start date Start date
S

Sikiru Olusanya

Dear reader,

I am working designing a program that involves reading
from a text file. The information in the text file is in
the form of a report eg payslip and not payroll. How can I
read such an information from such a text file to a
database file.

Sikiru
 
Sikiru Olusanya said:
Dear reader,

I am working designing a program that involves reading
from a text file. The information in the text file is in
the form of a report eg payslip and not payroll. How can I
read such an information from such a text file to a
database file.
Click to expand...

If it is truly a text file, and consistent in its format, you can read it
using the built-in File I/O statements, and parse it with your own VBA code.
If each payslip is a separate record, it is possible that you might be able
to import that file, or link to it and use the data where-is, as-is.

It being "in the form of a report" doesn't mean much of anything. You'd need
to describe in detail before anyone could be more specific... at worst
(again: if it _is_ TEXT, and not some other format) there would be printer
control codes imbedded. Can you examine it in Notepad and see what
information is there?

Larry Linson
Microsoft Access MVP
 
Back
Top