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
> How To Link Access And Excel With Ability To Data Entry From Both Of Them?, Access 2010    
 
   
Sami
post May 21 2019, 07:59 PM
Post#1



Posts: 33
Joined: 3-April 19



Hello
I didn't know where I must put my question, but I thought it's related with access more than excel.
I am looking for way to allow data entry in linked access and excel files.
Thanks in advance.
Go to the top of the page
 
theDBguy
post May 21 2019, 08:12 PM
Post#2


Access Wiki and Forums Moderator
Posts: 75,549
Joined: 19-June 07
From: SunnySandyEggo


Hi. Not sure I understand the full situation but I thought linked Excel files are "read-only," aren't they?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sami
post May 21 2019, 08:20 PM
Post#3



Posts: 33
Joined: 3-April 19



Thank you for your quick replay.
I have an excel file with huge date and many formulas, I convert my excel file into an access data base with query to deal with the formulas.
After that I linked access with excel from inside the excel file.
That was fine. But I think if I can edit data from both of these files it will be more effective especially after I get ride of the slowness in the excel file cause there is not any formula any more.
This post has been edited by Sami: May 21 2019, 08:37 PM
Go to the top of the page
 
theDBguy
post May 21 2019, 08:28 PM
Post#4


Access Wiki and Forums Moderator
Posts: 75,549
Joined: 19-June 07
From: SunnySandyEggo


Hi. Since I don't do anything like that, I am still lost. Are you saying, basically, you now have data in Access as tables and then created an Excel file that links to the data in Access? If so, aren't you able to update/edit the linked data from Excel?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Sami
post May 21 2019, 08:35 PM
Post#5



Posts: 33
Joined: 3-April 19



Exactly. First I transfered data from excel to access then I created new excel file and linked it with the access data base.
But i can't edit or add data from excel so I search way to make excel and access able to edit and add data.
This post has been edited by Sami: May 21 2019, 08:36 PM
Go to the top of the page
 
theDBguy
post May 21 2019, 09:57 PM
Post#6


Access Wiki and Forums Moderator
Posts: 75,549
Joined: 19-June 07
From: SunnySandyEggo


Okay. I won’t say it’s impossible but I know linked Excel sheets are read only. And if the opposite is also true, then I doubt there’s anything available to make it act differently. If so, I see your only option is to roll your own two-way update system. Good luck.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
MadPiet
post May 21 2019, 11:48 PM
Post#7



Posts: 3,132
Joined: 27-February 09



Short answer is you can't. I think it was possible in Access97 or so... but it hasn't been possible for a LONG time.
Go to the top of the page
 
Sami
post May 22 2019, 07:47 AM
Post#8



Posts: 33
Joined: 3-April 19



Thanks all of you
That is very comfortable so I accept these limits.
Go to the top of the page
 
GroverParkGeorge
post May 22 2019, 09:31 AM
Post#9


UA Admin
Posts: 35,146
Joined: 20-June 02
From: Newcastle, WA


My memory of the situation is that Microsoft lost a lawsuit regarding the technology used for two-way updating between Access and Excel. The least painful way to resolve that problem was to remove the ability to edit data in Excel files linked to Access.

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


Custom Search


RSSSearch   Top   Lo-Fi    20th June 2019 - 12:25 AM