Newbie to SQL Sever here.
In access it is very easy to set up linked tables using ODBC, the behavior of which is needed to replicate in sql server.
In SQL Server (2008 in this case), I found it easy to import using OBDC using the import wizard. What is not straightforward is either: 1. automating the actions if the import wizard or 2. creating linked tables similar to access. We need auto-refresh of the data rather than a manual update.
I have found articles dealing with how to link databases--which might also work-- but they all use a query analyzer feature that I haven't used before nor does 2008 seem to have this feature anyhow.
It seems there are a number of ways to solve this issue and that it should be simple as it is very much so in MS access. What am I missing?
Thank you,
John
In access it is very easy to set up linked tables using ODBC, the behavior of which is needed to replicate in sql server.
In SQL Server (2008 in this case), I found it easy to import using OBDC using the import wizard. What is not straightforward is either: 1. automating the actions if the import wizard or 2. creating linked tables similar to access. We need auto-refresh of the data rather than a manual update.
I have found articles dealing with how to link databases--which might also work-- but they all use a query analyzer feature that I haven't used before nor does 2008 seem to have this feature anyhow.
It seems there are a number of ways to solve this issue and that it should be simple as it is very much so in MS access. What am I missing?
Thank you,
John
Comment