UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Using Excel To Edit Access Data?, Access 2013    
 
   
dsabol2000
post Oct 16 2019, 11:04 AM
Post#1



Posts: 219
Joined: 28-February 05
From: Pennsylvania


I have users without Access licenses so I'm trying to build an Excel front end that they can use easily to edit/enter data into an Access table. I already have the table built and I can see it in Excel but if I enter anything into it, or change data it doesn't track back to Access. Is this something that is more involved than just accessing the data using the data connections menu in Excel? I've seen some complicated VBA stuff but it was outdated and I couldn't figure it out.
Go to the top of the page
 
GroverParkGeorge
post Oct 16 2019, 11:15 AM
Post#2


UA Admin
Posts: 36,206
Joined: 20-June 02
From: Newcastle, WA


How did you connect to the Access table from Excel?

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
GroverParkGeorge
post Oct 16 2019, 11:51 AM
Post#3


UA Admin
Posts: 36,206
Joined: 20-June 02
From: Newcastle, WA


I know it's not possible to directly edit Excel data from MS Access.

I don't think you can directly edit Access data from Excel.

I think you can write VBA and update the Access tables via ADO. However, there will be a learning curve, no doubt about it. On the other hand, if you plan to use MS Office applications long-term, it might be worthwhile to invest the effort and time to learn.

Have you considered giving users an Access FE that they can use with the FREE MS Access runtime?

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2019 - 10:43 PM