Importing Data Using ODBC Connection

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
Simon said:
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.
Click to expand...

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