Link to home
Start Free TrialLog in
Avatar of Jon888
Jon888

asked on

Linking Data from Excel into Access Tables

Is there a way of linking Excel data directly into Access Tables, by means of a button on a form?
ASKER CERTIFIED SOLUTION
Avatar of Don Thomson
Don Thomson
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PsychoDazey
PsychoDazey

I believe the TransferSpreadsheet will allow you to do this also.  Just run the code behind your command button.
Which method your use will depend on how data gets into your spreadsheet and whether or not it needs to be sychronized or simply copied
Jon888:

You last logged in on 11-January.

This is a free technical support site.

Experts who answer questions here receive no pay or other compensation except Expert points as a result answering questions and being awarded points.

As a result, and as a Moderator of this forum, my goal is to ensure that Experts and Askers alike no longer allow questions to get stale.

Please provide that feeback now. It's greatly appreciated!

If you need any help at all in cleaning up this or any other questions, don't hesitate to contact me via email. I will assist in any way that I can.

thanks
amp
community support moderator
amp@experts-exchange.com
Jon888:

You have several questions open:

https://www.experts-exchange.com/jsp/qShow.jsp?qid=20150628
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20150469
https://www.experts-exchange.com/jsp/qShow.jsp?qid=20085584

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator

2/4
Jon:

Please re-read #3. I give these instructions because they are EE standards. Please follow them.

thanks!
amp
community support moderator