I have a server with hundreds of LOG files.
All the files are labled: rep~%userid%.txt
In the Txt file are dozens of lines of Text like so:
; 32-bit CRC = A7DE8601
[]
Computer Name=LAPTOP-L10129
Logged on User=smithjo9
Automatic Logon=No
User is Admin=Yes
User’s domain=WOPR
User’s DNS domain=WOPR.USA.NET
Report date=2007-12-15 09:55:31
[HardwarePrinters]
WOPR-001413HPLJ8XPCA=HP LaserJet 8150 Series PCL
WOPR-001431HPLJ4ZPCA=HP LaserJet 4050 Series PCL
WOPR-001Q21HPLJ85PCA=HP LaserJet 8150 Series PCL
WOPR-001S62HPCL46PCA=HP Color LaserJet 4600 PCL 6
QUESTION:
How can I use MS Access to:
1. Look into this folder with hundred’s of TXT files.
2. Import a select number of lines
3. Convert them into a table
Thanks…..