Viswanath S. Dhara
SSC Veteran
Points: 234
More actions
June 12, 2008 at 10:51 pm
#121964
Hi,
I want to import MSACCESS files into an SQL Server 2005 table on a regular basis.
Is there anyway I can do it through a T-SQL Script? Like write a stored procedure or a job?
Thanks
Vishy
JamieX
Hall of Fame
Points: 3763
June 13, 2008 at 7:11 am
#828456
If you're just looking to transfer table data, create an SSIS package with a simple dataflow task.
Or you could look into the "SQL Server Migration Assistant for Access"
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply