<div>
SQL import\export wizard is the faster one in term of importing data from Access.
</div>


SQL import\export wizard is the faster one in term of importing data from Access.

<div>
Perhaps, but I have 22 tables I have to import every time I run a test on what I'm working on. I sometimes run a test 5-6 times a day so I'd prefer to have a script I can run once per import
</div>


Perhaps, but I have 22 tables I have to import every time I run a test on what I'm working on. I sometimes run a test 5-6 times a day so I'd prefer to have a script I can run once per import

<div>
<div class="content wysiwyg-content">
I have several Access tables I need to import into SQL Server and currently do that using the Import Wizard in SQL.<br />
Is there a way to write a script listing the tables to make the process easier and faster?
</div>
</div>


I have several Access tables I need to import into SQL Server and currently do that using the Import Wizard in SQL.
Is there a way to write a script listing the tables to make the process easier and faster?

SQL Import Scripts

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.