Jegajothy vythilingam
asked on
DAO code
My OS is win 7 prof 64 bit and I have office 365. i have an ASCIi text file which has data in the following format :
James Doe (jDoe@gmail.com);
I want to read this file, line by line,
1. to read until before the ( and then copy and paste to a variable;
2 from ( ... ) to copy the email
3. And then to open a table which has already been created, and append the 1. to a field called Xname; and the 2. to a field called yemail.
4. The end of the line is denoted by ";",
5. and continue processig until the end of the file.
has anyone a sample code that could do something like this or close to it, I would appreciate it. Thank u.
James Doe (jDoe@gmail.com);
I want to read this file, line by line,
1. to read until before the ( and then copy and paste to a variable;
2 from ( ... ) to copy the email
3. And then to open a table which has already been created, and append the 1. to a field called Xname; and the 2. to a field called yemail.
4. The end of the line is denoted by ";",
5. and continue processig until the end of the file.
has anyone a sample code that could do something like this or close to it, I would appreciate it. Thank u.
Couldn't you read the whole file into a table then use an update/append query to put/add the data into the 2 fields in the existing table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is the solution, I was expecting, and I wish to inform u that the solution works 100% correctly. Thank u very much.