<div>
VB5.0 or VBA in Access?<br />

</div>


<div>
I'm using VB5.0, Thanks!<br />

</div>


<div>
In MSSQL server 7.0 beta you can use data transformation services to import data it is windows based, fast and handy<br />
you can select multiple tables. I do not know it is challenging<br />
but perhaps it can replace this heavy job cymbolic is doing.<br />
Put still we need to create tables firs with code, if we import into new table we loose indexes and relationships.<br />
<br />
<br />

</div>


In MSSQL server 7.0 beta you can use data transformation services to import data it is windows based, fast and handy
you can select multiple tables. I do not know it is challenging
but perhaps it can replace this heavy job cymbolic is doing.
Put still we need to create tables firs with code, if we import into new table we loose indexes and relationships.




<div>
<div class="content wysiwyg-content">
How can I import table from Access to SQL Server in VB code?
</div>
</div>


How can I import table from Access to SQL Server in VB code?

Import  table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.