Importing only one field from Excel into an Access Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Ahmad,

In general it's best to import or link the Excel sheet so it shows up as
a table in Access. Then use queries to manipulate the data as you need.


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
Click to expand...
 
Back
Top