Linking Access and Excel - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 04-23-2004, 02:01 PM   #1 (permalink)
Newb Techie
 
Join Date: Apr 2004
Posts: 1
Default Linking Access and Excel

Hi all,

I'm trying to link data between Excel and Access. Ideally, I want users to enter data into an Access form, which will transfer data to an Excel spreadsheet, do calculations and send it back to Access as a visual output for the user.

I know by using an Excel add-in (Access Link) I can set this up and I have done successfully. I now have two files, one Access one Excel, that transfer data between each other. However, it is not portable, ie, if I transfer the two files to another computer, the link breaks, even if the versions of Access and Excel and the OS are exactly the same and if the add-in is installed,

I was hoping someone could tell me if there was a way to keep that link when I take the files to another PC or if there is another way of transfering data between the two applications.

Regards,
Ryad.
__________________

Ryad is offline  
Old 04-23-2004, 09:51 PM   #2 (permalink)
Banned
 
Join Date: Apr 2004
Posts: 49
Default

Try to look for it in the tool bars, there is function for the purpose.
__________________

mitch is offline  
Old 04-24-2004, 01:24 AM   #3 (permalink)
Master Techie
 
Join Date: Mar 2004
Posts: 2,007
Default

What version of excel and access are u using?

There should be an "autoupdate" of the link when you open excel. Check out the following link, this might help.

linking excel and access

Another option is to use cdrw where the data can be retrieved and replaced with new data. But that's not too convenient.

What kind of calculations are being done in excel? Access has a wide range of functions and calculations that can be done from the data that is entered in to a form then queried and outputted into a report.
jaksback is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 11:48 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.