• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2567
  • Last Modified:

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?
0
rhg1
Asked:
rhg1
  • 2
  • 2
1 Solution
 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now