SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SQL Server to .ACCDB		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Johnph
Yak Posting Veteran

75 Posts
Posted - 09/18/2012 :  13:47:56  Show Profile  Reply with Quote
Hello,

What destination do I use for a SQL Server to .ACCDB database in an SSIS package? I assume ADO but not seeing an option to let you pick a file. Apologize if I am posting in the wrong section.

edit: moved to proper forum

prett
Posting Yak Master

USA
161 Posts
Posted - 09/19/2012 :  00:48:44  Show Profile  Reply with Quote
You can use "Import and Export wizard" to importing Access database tables into MS SQL Server. You can find full steps from here: http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000