I am trying to put an excel table of info into a data base. Each item has to have its own field.
Is this possible?

I want to link the application in version "m" to the tables in version "k", since user already entered several records.  I intend to make those tables the real database from here on out, so any future fixes/enhancements would be handled the same way.  In other words, we would ...

I am looking for an answer to the following senario:
For a schools, I record the number of students in the Year and student
participation in Activities.
The number of students who are currently in the Year (eg: 6,7, or 8), become

I need to retrieve records based on a selected General
Ledger Accounting period of month and year.  Can I store
the date in the format of mm/yy in a table field?  If so,
how do you create that format?  If I cannot store data in

I have a table with an AIN as primary key, 2 users, and have observed that some numbers in the sequence are missing, eg 1,2,3,4,7,8,10,11,12. Users cannot delete these records so I'm puzzled. Thanks.

I have a table with the following fields:
OrderNumber
OrderLocation
OrderID

My form contains a listing of linked Word templates for the user to choose from (based on a table with hyperlink fields).  The Word templates have automation built in, with fillin’ fields and some have merge fields based on access table data.  When the user opens the linked ...

I am trying to write a code where A=1, B=2, C=3 then add each letter value to get a total
for instance "cat" would be 3+1+20=2
I am trying to find way to return the number of occurances of a letter in a field then multiply by the the set value. I was planning on doing this for each ...

Have a volunteer database with several tables. One is
Organizations where any new entry has an ID designated
with an AutoNumber which is also the primary key. When
data is entered, the related tables (e.g. Contribution)

can anyone tell me the most straight forward way to display a different graphic for each record i.e employee records

This is from a previous post.......Lets back up all of
these fields came from 3 different forms. This is how it
works we get a call in from someone about a private or
commercial site that has waste and trash on it. The

I want to be able to copy a record from one table and
place that record in another table and deleting it from
the original table in the process in a click of a button,
is this possible?

A very strange one....
I recently experienced 'lost' data in a table (yes, it's
true - I am not going loopy!!).  The background is that
through DAO I imported data from another database into a

I am trying to link serveral tables to one specific item
in a main table. How is this done? Do I need a query? I am
a bit of a beginner so sorry if question might seem silly.

Could you please advise the maximum amount of records that
MS Access can store in a table?