Update Queries

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have emails being exported from Outlook into Access. I then would to take
certain data in the body of the email into another field. The emails are
automatically generated, and are always in the same format although the data
I want to pull out can change (the length will always be the same). I have
been able to get a calculation query to pull the data I would like to have
pulled out but I can not figure out how to get the data into permanent fields.
 
Read the help files on types of Access action queries. One is an append query
that adds records to the bottom of an existing table. Another you may want to
use is an update query which adds records to the fields of existing tables.
Use a make-table query to build your table with the first data and then
either a append or update query to add data.
 
I have a very similar problem as Nick.

I have attempted to use a "Make Table Query" for a very simple query.

The Datasource Nick and I are using is ODBC SQL Database from Outlook
Business Contact Manager. I have created a dynamic link to this SQL server
and assume Nick has done the same.

The issue for me is that the data in certain KEY fields is in MEMO format,
not TEXT Format. I have been attempting to truncate and convert the Memo
Field into a TEXT field using Query without success.

I then attempted to use Make Table Query. To Create a local (and editable)
database. (Using ODBC to access the MS OUTLOOK BCM SQL database, I can only
view records, can not change them or the underlying file structures)

The Make table Query will run and I can view the data in the spreadsheet
view: BUT IT WILL NOT CREATE a new TABLE. ~ Seems very odd.

Please help
 
Are you running the query by using Query: Run from the menu?

Simply switching to Datasheet view does not execute the query. It only
show you what the results would be if you did run (execute) the query.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top