Data Entry Into Tables

[raychow22]

Hi Forum,

Is there a easy way to edit existing data from tables. I know it's bad practice to edit Data from Tables, but can it be as easy as excel where I can copy and paste things into it. The only way I can think of is Importing and Exporting excel data and using a query to match thing uniqueID.



Is there any other way?

Thanks!

[orange]

For general approaches to import excel data to Access--

Try searching with Google to find options and examples for importing Excel data into MS Access
with this criteria:
How to import excel data into ms access

Here' a youtube video by Steve Bishop on the subject
https://www.youtube.com/watch?v=WO7Js1Mh13c

[June7]

Don't really understand issue. It certainly is easy to edit data directly in table. And yes, can copy/paste. But I don't recommend allowing users to do it.