Import excell sheet into access, then add new fields to access MDB

[Guest]

I have a parts list that I import from a web page into excell with no
problems. Then I import the excell sheet into access and this works fine as
well. The problem is adding a new field to the access database after this
procedure. It says it's linked and won't allow me to modify the database
with new fields. I would appreciate any ideas. Thanks

 

[John Vinson]

I have a parts list that I import from a web page into excell with no
problems. Then I import the excell sheet into access and this works fine as
well. The problem is adding a new field to the access database after this
procedure. It says it's linked and won't allow me to modify the database
with new fields. I would appreciate any ideas. Thanks

Sounds like you *linked* the spreadsheet, rather than *importing* it.
These are two options on the File... Get External Data menu option; a
linked file leaves the data in Excel, importing it creates an Access
table (which *can* be altered).

John W. Vinson[MVP]

 

[Alan]

Hi John,

If the OP did in fact use *linking* rather than *importing*, he might want
the to maintain the ability of having the data dynamically updated.

If that's the case, I think it's possible for him to use a make-table query
to take the currently-linked Access table and create a brand new table into
which he can add a new field.

Alan