-
I need to fetch the data from MS-Access to SQL-Server
I want to fetch the data from MS-Access to SQL-Server 2000 and for that i got the solution here
http://forums.databasejournal.com/sh...ad.php?t=43915 using DTS package in scheduled job. This is works good in my machine (i created one sample MS-Access file and i fetching data from SQL-Server). When i try to connect the MS-Access file which is from my collegue machine it is scheduled (I created DSN for this) but if that MS-Access file is get updated then that time the job scheduled get failed.
Could anybody help me to solve this issue?
Thanks in advance...
Venkatesh
imtesh@gmail.com
-
any other idea...
Let me know if anybody nows some other way to fetch the data from access to sql server.
Thanks
Venkatesh
imtesh@gmail.com
-
How about using Linked server
-
I am not able to fix
In that link they didnt mentioned abt how to connect linked server to MS-Access database. So pls give me some other solution.
Thanks in advance
venkateshv
imtesh@gmail.com
-
EXEC sp_addlinkedserver
@server = 'SEATTLE Mktg',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = 'C:\MSOffice\Access\Samples\Northwind.mdb'
GO
You can find details in sql books online.
-
pls come again..
@server = 'SEATTLE Mktg' here 'SEATTLE Mktg' means?
wat i need to mention for@server=?
venkatesh
-
That's linked server name, can be any name you like to use.
-
thanks
Its working thanks... but i need to fetch the data from ms-access to sql server for every 5 minutes. if any updation taken place in ms-access that need to reflect in sql server..
is there is any timer function is the sql server to perform this function.
Thanks in advance
venkatesh
-
update me...
Is there is any timer function in sql server to call the stored procedure. if so pls post here...
thanks
venkatesh
-
You can schedule a sql job for that.
-
could you please help me for that?
I am new to sql server. So could you please help me how to schedule that linked server. please...thanks...
venkatesh
-
Create a sql job, run that sp as command under correct db. Check books online for details.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|