linked tables for xl 1

[surfside1]

I have a real "general question" about Access creating a linked table to an XL worksheet. Can anyone give their opinions about the implications of using a linked table instead of an imported table although I realize it allows them to get the latest updated date. Or can you point me to something I can read. I have a client that wants to add a column to a linked table, but when they view the result of the link manager the table no longer has the new column. My suggestion was to add it to the worksheet but because I know nothing about this, the new column is not added. They are working to get the original programer who extracts the data to XL from another system to add that column, but they don't know when they will.
Sorry if this too general.....Thanks!

 

[surfside1]

What I meant by "Updated date" I meant "Updated values created in XL". Sorry

 

[ajetrumpet]

If you link an Excel worksheet to an Access DB datasheet,
new data can be entered in any object, in Access or Excel, doesn't matter. It automatically appears everywhere. I don't think you can modify fields (columns) of an Acess datasheet if its source is a linked XL worksheet.

 

[surfside1]

Thanks,
So the changes need to made to the Worksheet first, right?

 

[ajetrumpet]

If your changes are being made to DATA, you can make them in the DB or the XL. If you are making changes (any changes) to columns, you have to make them in XL. Access won't allow it, because its table is not a source object.
I hope I could help. =) Good luck.

-J

 

[surfside1]

-J, thanks you were of help!
-C