How to INSERT COLUMN in Access Databaes

hello,
opened ms Access (2000)
opened xl spreadsheet into Access ( as I wish the spreadsheet to become a database)
Cannot insert a new field in form view (no button or menu item to do this and
cannot insert a new column in list view ( "insert column" is grayed out)
vot to do?
rhg1Asked:
Who is Participating?
 
TheSloathCommented:
Import the XLS rather than linking it(File|Get External Data|Import).

Then you will be able to change the resultant table as you wish.
0
 
TheSloathCommented:
You've been into Design View of the Table?
0
 
rhg1Author Commented:
thanks Sloath
further - it seems i can't make some adjustments as my tbel is linked to access
didn't want this can I unlink?
can I establish a data key now that teh database is already set up?
0
 
rhg1Author Commented:
I MEANT linked to excel. i don't want an excel table in access. i want teh spreadsheet to become the access database. i f i follow the instructions in help to unlink the excel spreadsheet, the table is deleted
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.