K
Kiran
Hi,
I'm new to both Access and VBA.
I have a text file with multiple fields to be imported to access.
But text file does not have fixed width.
Some fields have multiple lines of data. Example:
Name: John
Designation: Supervisor_Thermal
Responsibilities: line1
line2
line2
Achievements: line1
line2
Shift: general
I have created a table with the respective fields.
I can import fields, using macro, which end in the same line by using InStr.
But I don't know how to import fields with multiple lines.
Also, please note that there are thousands of records with this format
continuing in the same text file.
Any help would be greatly appreciated.
Thanks,
I'm new to both Access and VBA.
I have a text file with multiple fields to be imported to access.
But text file does not have fixed width.
Some fields have multiple lines of data. Example:
Name: John
Designation: Supervisor_Thermal
Responsibilities: line1
line2
line2
Achievements: line1
line2
Shift: general
I have created a table with the respective fields.
I can import fields, using macro, which end in the same line by using InStr.
But I don't know how to import fields with multiple lines.
Also, please note that there are thousands of records with this format
continuing in the same text file.
Any help would be greatly appreciated.
Thanks,