I have an Access table that simply has 8 fields. First 4 fields
contains data and last 4 does not. My user needs to come to this table
and enters data for the last 4 empty fields,
Now the problem is that my users are not familiar with Access so they
make lots of mistake and they get frustrated because they cant do the
same operations that they can do in Excel in Access like easy copy and
past or drag and drop. So here is what I need:

I need to find an easy way to make an Access table or form to be
editable by like Excel.
is there a plug-in for access that makes it more like excel? Is there
a way that I can get the user to push a button on my access form,
which opens my Access table in excel for user and is there any way
that I can tell to that excel that when someone push the save button,
save the data back to the original Access table? Can you tell how ?

---

Request for Question Clarification by cynthia-ga on 22 Jul 2006 05:45 PDT

Why not convert your Access tables to Excel, which they are
comfortable with, and when they are done, convert it back to Access?
Seems easier than teaching data entry people something new.

Here's a few ideas:

access excel converter
://www.google.com/search?num=50&hl=en&lr=&safe=off&q=access+excel+converter

---

Clarification of Question by radyar-ga on 31 Jul 2006 22:25 PDT

I dont want to make it hard on them, most people are not ok with the
whole import/ export procces.

---

Request for Question Clarification by cynthia-ga on 04 Aug 2006 19:11 PDT

THey don't have to be comfortable with it. They can work with Excel,
and when you want it in Access, YOU can convert it.

There is a way to achieve what you want.

You can write code to do the following:

1.  Code to export table to excel
2. Code to import from excel to access.

With this solution they would push a button on teh form to export and
another button to import.  A simple user solution.  You can also use
automation to open the excel file after step 1.

can help with code for that.

I've got a better idea. It?s much more simple than coding.

Make your table first in Excel. Include all the fields you need and
format them appropriately. Then, go into Access. Go to the tables
section. Click on ?New? and then select ?Link table??  You will have
to change the file type in order to link to an Excel file.  Once the
link is established, whatever is in the Excel table is available to be
read in Access.

A few words of wisdom. I know for a fact this technique works in MS
Access 2000. As for earlier versions, I cannot guarantee the same
outcome.  Also, I think the Excel table will need to be saved for the
changes to reflect in Access. Lastly, do not attempt to make any
changes to the Excel file through Access. I tried it once and it
corrupted the Excel file. But not to worry, Access warns you first if
attempt to change the data.

If you need to make changes to the table in Access, I recommend using
a Make table query to capture the Excel data and save it as an Access
table. After the table is adjusted in Access, you can always copy and
paste it back into the linked Excel file.

I hope this helps.

There is an excel-like datagrid view BUILT IN to access.  In access,
create a new form based on your Table (click on forms->Create form
using Wizard, it will walk you through the entire process).  When a
user opens the form, all they have to do is click view->datasheet view
and it will look EXACTLY like Excel.

If you want to get real tricky, you can change the default form view to Datasheet:

Open the form, and click view->design view
Then click on view->properties
Choose "Form" from the drop down at the top of the properties window.
Change the "Default View" to datasheet (default view should be on the
"Format" tab of the properties window

Want to get SUPER-tricky?  Set it up so that when the user opens the
database the Datasheet window opens AUTOMATICALLY:

In Access, with your database open, click Tools->Startup
There should be a drop-down box labeled "Display Form/Page"
Select your newly-created form from that dropdown box, and now the
form you created will open automatically when they open the database.