CODEWITHSUNDEEP
sql-serverms-access
kamiar3001
kamiar3001

Reputation: 2676

how ms-access and sql server interact each other?

I have an ms-access database and I need when ever I add a record to my table automatically add a similar record to sql database how it is possible ?

Edit: How I can create an SSIS package(s) and set SQL Server Agent run to periodically load the data?

Upvotes: 0

Views: 163

Answers (1)

PJB
PJB

Reputation: 390

If you are using SQL Server 2000 you can use replication. But this feature is deprecated from SQL Server 2005 onwards. See http://msdn.microsoft.com/en-us/library/ms143470.aspx.

Assuming that you are on a later version, there are a couple of options I can see:

1) Migrate from Access to SQL Server Express and use replication.

2) Create an SSIS package(s) to import the data. The package(s) can be scheduled in SQL Server Agent run to periodically load the data.

Upvotes: 1

Related Questions