Importing from Excel -certain field

  • Thread starter Thread starter AK
  • Start date Start date
A

AK

If I have a table in Access with 4 fields:
ID,
Last name,
First Name,
SS

The ID is Primary Key.

example:

ID L.Name F.Name SS
AK01 Karim Abid
TH01 Herry Tom
JS01 Scott John

The SS number is blank

I need to update the SS number from an excel speadsheet.


How would load (update) one field from the excel (ss field
only) into Access?

I have tried 'Get external Data... but getting problems in
loading...
 
What problems are you encountering through Get External Data?

I would think that the easiest approach would be to link to the Excel
spreadsheet (as opposed to importing), then write an Update query that joins
the linked Excel table to your Access table.
 
I would prefer importing - I am not good with query
statements.

The error message is ' Unable to append due key
violations...

Thank you!
 
If I understand what you are saying, I would do this.
1. Import the excel spreadsheet
2. create a query with the Access Table and the imported Excel table.
3. Join the tables on ID.
4. Change the query to an update query
5. In the first column of the grid area add the Access Table ID field.
6. In the "Update to" row of the first column enter the ID information
from the Excel table.
exp [Name of Excel Table].[SS] in the "Update To" Row.
7. Save it.
8 Run it.

This should update the SS number in the Access table from the Excel
table where both
records have a match on ID.

Also you should make a copy of your Access table before your run the
update query
just in the event something goes wrong.
 
I need a Query that will import, only, the [web_ID] field
from Total1.xls into sheet1.[web_ID] in Access

then, updates the sheet1.[Total] to Total1.[Total]
where Sheet1.[Web_ID] = Total1.[Web_ID]

this is the layout of the Table sheet1 in Access !

Sheet1:
Sheet_ID Web_ID Name Total Percentage
AutoNumber web1 yahoo 50 5
" web2 google 70 7

Thanks a lot !
AHMAD
-----Original Message-----
If I understand what you are saying, I would do this.
1. Import the excel spreadsheet
2. create a query with the Access Table and the imported Excel table.
3. Join the tables on ID.
4. Change the query to an update query
5. In the first column of the grid area add the Access Table ID field.
6. In the "Update to" row of the first column enter the ID information
from the Excel table.
exp [Name of Excel Table].[SS] in the "Update To" Row.
7. Save it.
8 Run it.

This should update the SS number in the Access table from the Excel
table where both
records have a match on ID.

Also you should make a copy of your Access table before your run the
update query
just in the event something goes wrong.

Ron said:
If I have a table in Access with 4 fields:
ID,
Last name,
First Name,
SS

The ID is Primary Key.

example:

ID L.Name F.Name SS
AK01 Karim Abid
TH01 Herry Tom
JS01 Scott John

The SS number is blank

I need to update the SS number from an excel speadsheet.


How would load (update) one field from the excel (ss field
only) into Access?

I have tried 'Get external Data... but getting problems in
loading...
Click to expand...

.
Click to expand...
 
Back
Top