IMPORTING A SINGLE EXCEL FIELD

[William]

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,

 

[Jeff Boyce]

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]

Sorry for the poor terminology. I want to import 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.

 

[Ken Snell \(MVP\)]

Delete the data from the ACCESS table using a delete query. Then import the
EXCEL data using the TransferSpreadsheet action (macro or VBA) to that
table.

 

[pietlinden]

Delete the data from the ACCESS table using a delete query. Then import the
EXCEL data using the TransferSpreadsheet action (macro or VBA) to that
table.

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

 

[William]

Thanks to everyone for responding.
--
William

Delete the data from the ACCESS table using a delete query. Then import the
EXCEL data using the TransferSpreadsheet action (macro or VBA) to that
table.

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