how to automate the data transfer from SQL Server 2005 to MS Access?

hi,

please give me some idea how to do this?

asked Oct 09 '09 at 02:28 PM in Default

madan
11 ● 1 ● 1 ● 1

(comments are locked)

2 answers:

Well, an SSIS package is one way.

answered Oct 09 '09 at 10:53 PM

RBarryYoung 1
71 ● 1

(comments are locked)

From SQL Server you could have the SQL Server Agent execute an SSIS package or even simply use a linked server to Access and put the data in Access from straight SQL. I would prefer this method if your use of Access is as a data transport mechanism, and if you have good control over your SQL Server environment.

Although Access does not have built-in scheduled automation like the agent, you can also have Access pull data using a linked table to a table or view in SQL Server. I would prefer this method if you already have a lot of code in Access or your rights to administer SQL Server is limited.

There's always the option of writing something externally in just about any other platform.

answered Oct 11 '09 at 08:05 PM