Update field with single row of info

[topdesk123]

Good morning all!

I have a text file that I import into Access 2003. The first line of the text file contains the date the email was sent and the project name. The following rows contain the email addresses and status (success, failed, etc). I'm trying to figure out how to update each record (email address, status) with the date and project name.

The table looks like this:

Email Status Project Date Req ID
Mailer 1/19/2005
Project testemail
email1@server.com: success 2
email1@server.com: success 3
email1@server.com: success 4
email1@server.com: success 5
email1@server.com: success 6

Any thoughts would be much appreciated!

 

[HitechUser]

topdesk123,

You could create a link to your text file using TransferText.

 DoCmd.TransferText acLinkFixed, ,<TableName>, strFile, <HasFieldNames>

Reading the file, you can then (using string fuctions) "retrieve" your date from the string. From there perform an update query (with the value retrieved) to your table.

Hey just an idea...