Solved

How to INSERT COLUMN in Access Databaes

Posted on 2007-04-03
4
2,556 Views
Last Modified: 2013-11-28
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
Comment
Question by:rhg1
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:TheSloath
ID: 18847824
You've been into Design View of the Table?
0
 

Author Comment

by:rhg1
ID: 18847907
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
 

Author Comment

by:rhg1
ID: 18847954
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
 
LVL 9

Accepted Solution

by:
TheSloath earned 50 total points
ID: 18849044
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question