July 28, 2008 at 2:53 pm
Hi
I have an Access db. I have to pull one of the tables in this db to sql server 2005. This is not a one time task but has to be repeated daily.
What is the best way 2 achieve this.
Can u also provide the detailed steps to achieve this.
Thanks
July 31, 2008 at 7:59 am
Hi,
Assuming you don’t want to set up your Access DB as a Linked-Server, you can use SQL 2005's Import wizard to perform a one off data load. The wizard then gives you the option to save the load process as an SSIS package. Once saved, you can schedule the SSIS package to execute daily.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
July 31, 2008 at 2:44 pm
I had something similar to this and what I did was established a linked server and query the table as if it is part of sql server.
e.g. select top 100 * from myaccessDB...myAccessTableIf you have dates in access < 1753, you will encounter errors, which you can handle using openquery()
If you need further help linking your ms access DB, post back.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply