synchronizing excel and access

[Danielle]

I have a database of address that are downloaded from the internet to excel.
I have imported the data to access to create mail-outs easily, however, it is
necessary for me to keep the excel worksheet- as this is my only application
option when downloading the data. Some addresses have to be removed because
they are returned, so I remove them from excel and access seperately. Is
there a way to synchronize the database from access to the worksheet in excel
so that all I need to do is update excel and access will automatically update
itself?

Thank you,

Danielle

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1

[pietlinden]

Why not just link the SS to Access by creating a linked table? Then
you can query it as if it were inside Access.

If you link to it, you're leaving the data in Excel, but are able to
manipulate it using queries etc.

If you need to have the data in Access as well, you can import and then
use the linked Excel file to do updates etc.

[Tom van Stiphout]

On Tue, 22 Nov 2005 20:25:22 GMT, "Danielle" <u14899@uwe> wrote:

Yes there is. Rather than importing the data, LINK to them. File /
Get External Data / Link tables.

-Tom.

I have a database of address that are downloaded from the internet to excel.
I have imported the data to access to create mail-outs easily, however, it is
necessary for me to keep the excel worksheet- as this is my only application
option when downloading the data. Some addresses have to be removed because
they are returned, so I remove them from excel and access seperately. Is
there a way to synchronize the database from access to the worksheet in excel
so that all I need to do is update excel and access will automatically update
itself?

Thank you,

Danielle