Thanks to everyone for responding.
--
William
"pietlinden@[EMAIL PROTECTED]
" wrote:
> On Aug 2, 10:59 am, "Ken Snell \(MVP\)"
> <kthsneisll...@[EMAIL PROTECTED]
> wrote:
> > Delete the data from the ACCESS table using a delete query. Then
im****t the
> > EXCEL data using the TransferSpreadsheet action (macro or VBA) to that
> > table.
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> >
> > "William" <Will...@[EMAIL PROTECTED]
> wrote in message
> >
> > news:CE155F1E-C8EE-468F-8CA8-84167F596DBA@[EMAIL PROTECTED]
> >
> > > Sorry for the poor terminology. I want to im****t a column from
excel with
> > > 57
> > > rows into a column in access with 57 rows. I want the excel column
to
> > > overwrite the data in the access column.
> > > --
> > > William
> >
> > > "Jeff Boyce" wrote:
> >
> > >> William
> >
> > >> I'm confused...
> >
> > >> You seem to be using the term "field" to mean ... ?a field (that
holds a
> > >> single piece of data) ... ?a table that holds rows (i.e., sets of
> > >> data/fields) ... ?something to do with an Excel file.
> >
> > >> In Access, a field is another term for a column -- the field/column
holds
> > >> a
> > >> single fact in a single record. The same field (think "LastName")
will
> > >> show
> > >> up in every row in the table, but any one row will only have one
> > >> "LastName"
> > >> field.
> >
> > >> More info, please...
> >
> > >> Regards
> >
> > >> Jeff Boyce
> > >> Microsoft Office/Access MVP
> >
> > >> "William" <Will...@[EMAIL PROTECTED]
> wrote in message
> > >>news:3B3E1D5D-80A1-49F4-BFB6-065838777FD6@[EMAIL PROTECTED]
> > >> >I have a field in an access field named ALLOCATIONS. I want to
> > >> >overwrite
> > >> > this field with new data from a field in an excel file (same
number of
> > >> > rows).
> > >> > I can't seem to find the combination of linking or getting
external
> > >> > data
> > >> > to
> > >> > make this work. Can anyone give some guidance?
> >
> > >> > Thanks,
> > >> > --
> > >> > William
>
> sounds more like he wants to run an update query to overwrite just the
> single column... or maybe I'm wrong. If that's the case, join the two
> tables on the primary key/unique field, and set the "update to" value
> to [tablename].[fieldname] of the excel column
>
|
