Importing Data Using ODBC Connection

[Simon]

Hi There,

I want to import data into a MS Access database from a SQL Server database
using an ODBC Connection. I then need to create a macro to manipulate the MS
access data. I only want to manipulate the access data, I don't want to
change/manipulate the original data (the data in the SQL) server. If I
create a macro to iterate over my MS Access database and make updates to that
data, is it going to update the data in the SQL Server as well? I hope it
wont.

Thanks.
Simon

 

[Rick Brandt]

Hi There,

I want to import data into a MS Access database from a SQL Server
database using an ODBC Connection. I then need to create a macro to
manipulate the MS access data. I only want to manipulate the access
data, I don't want to change/manipulate the original data (the data
in the SQL) server. If I create a macro to iterate over my MS Access
database and make updates to that data, is it going to update the
data in the SQL Server as well? I hope it wont.

If you imported the data into local tables it won't. If you created links
then it will.