linking data

amitshah · Apr 22nd, 2002, 11:12 PM

I want to link data from a database say MS Access to my sheets in excel. What is the best way to do this?

I also want that when data is imported only the data that matches a certain criteria is imported.
I need the data for say sheet 1 to come from two or more access tables or queries. The size of these
tables and queries can vary therefore you cant really know how many rows of data will be
imported. But if possible I want it to be imported as one big list from the database even though
it comes from different tables or queries.

Can I automate the process of checking everytime I open the sheet, that it checks from the
source if there has been any changes to the database. If there are changes then it reloads
the data or if no changes then no action is taken.

How do I go about this? Any ideas? If it involves using VB or VBA please give a few hints
cause I am new to it and learning. Thanks.

gareth · Apr 22nd, 2002, 11:49 PM

Hello buddy

I am not saying this will solve your problem,but what I normally do is,-If the file is in access,I export it to excel and vice versa,then I do the tricks neccesary.You can try the same,If it does not work for you I suggest you wait for more suggestions.I will monitor this one closely for I also might learn something new today

Regards

Gareth Lombard

Ŏ¿Ŏ⌐

amitshah · Apr 23rd, 2002, 07:21 PM

Hi gareth thanks for the help. I am already doing that but was wondering if there is any other way that would link it.

Any help appreciated. Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 11:12 PM	#1
amitshah Board Regular Join Date: Apr 2002 Posts: 80	I want to link data from a database say MS Access to my sheets in excel. What is the best way to do this? I also want that when data is imported only the data that matches a certain criteria is imported. I need the data for say sheet 1 to come from two or more access tables or queries. The size of these tables and queries can vary therefore you cant really know how many rows of data will be imported. But if possible I want it to be imported as one big list from the database even though it comes from different tables or queries. Can I automate the process of checking everytime I open the sheet, that it checks from the source if there has been any changes to the database. If there are changes then it reloads the data or if no changes then no action is taken. How do I go about this? Any ideas? If it involves using VB or VBA please give a few hints cause I am new to it and learning. Thanks.

Apr 22nd, 2002, 11:49 PM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Hello buddy I am not saying this will solve your problem,but what I normally do is,-If the file is in access,I export it to excel and vice versa,then I do the tricks neccesary.You can try the same,If it does not work for you I suggest you wait for more suggestions.I will monitor this one closely for I also might learn something new today Regards Gareth Lombard Ŏ¿Ŏ⌐

Apr 23rd, 2002, 07:21 PM	#3
amitshah Board Regular Join Date: Apr 2002 Posts: 80	Hi gareth thanks for the help. I am already doing that but was wondering if there is any other way that would link it. Any help appreciated. Thanks.