Access Field Not Updating

[Excel_77]

I have an Excel spreadsheet uploaded to Access, and created a table in Access for it to feed into. I needed a new field so I updated my source spreadsheet and added the field into my Access table, however the information from the Excel spreadsheet has not fed into my Access table, what could be wrong?

I've refreshed the tables and the link is working.

I'm very new to Access.

 

[Excel_77]

Same problem, deleted all instances of the table and uploaded a new table and created a table to feed into which again doesn't pick up any of the data within the source excel spreadsheet.

 

[Joe4]

If you uploaded a new table, what then are you creating? Uploading the data already creates the table?
Please explain, in step-by-step detail exactly how you are importing the data and whatever else you are doing.

 

[Excel_77]

Ok imported the spreadsheet using the link feature, the spreadsheet is called source, this appears in Access as an Excel logo.

Next I go to the Access table that has all the data and headings within it and I refresh this link in the "Linked Table Manager" section and then when I access the table the filed called Currency is still blank.

 

[welshgasman]

The linked table with the Excel logo IS the Access table.
I have just taken a sheet and linked to it from Access. I then went in and added another column.
That columnappears immediately in Access when I next open the table.

So it appears you are going one step to far. the data you should be using is in the table with the Excel logo. That is just indicating that the table is linked to an Excel sheet.

 

[Excel_77]

So what is the Access table above it relating to? Also I have a form below, how do I get this new field to feed into it?

 

[welshgasman]

I also based a form on the XL table (let's call it that to distinguish between an actual Access table)
Just add fields as you normally would in this situation, be it an Excel linked table or Access table.
If you do not know how, open form in design mode, then click on the Add Existing fields icon

 

[xenou]

It's possible the particular data in the spreadsheet is not getting picked up by Access. What's in the column?