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

C

clone123

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
 
J

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

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]
 
A

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
 
Top