<div>
What is the format for your source?<br />
Is it a text file?<br />
Then use DTS.
</div>


What is the format for your source?
Is it a text file?
Then use DTS.

<div>
To Imran fast<br />
Actually I need to transfer periodically aN MsAccess table to An MsSql table<br />
I am using ASP/VBscript/ADO<br />
I simply use rs.getrows to create the array with code.<br />
I assumed this would the quickest method since a text file would require 6000 disk accesses<br />
The only access I have to the MsSql is through an admin tool which is provided by ny webhosting company and does not have DTS enabled.<br />
Your input is appreciated<br />
thank you<br />
Dory
</div>


To Imran fast
Actually I need to transfer periodically aN MsAccess table to An MsSql table
I am using ASP/VBscript/ADO
I simply use rs.getrows to create the array with code.
I assumed this would the quickest method since a text file would require 6000 disk accesses
The only access I have to the MsSql is through an admin tool which is provided by ny webhosting company and does not have DTS enabled.
Your input is appreciated
thank you
Dory

<div>
&lt;&lt;well, the fastest would be the following:<br />
create a linked table from access pointing to the mssql table, and then do a simple insert (append) query from the access table to the mssql linked table.&gt;&gt;I concurr...use that method and package it in a scheduled job...
</div>


<<well, the fastest would be the following:
create a linked table from access pointing to the mssql table, and then do a simple insert (append) query from the access table to the mssql linked table.>>I concurr...use that method and package it in a scheduled job...

<div>
<div class="content wysiwyg-content">
Hi Guys<br />
I have to insert an array of 6000 rows and 50 columns to an existing remote mssql table<br />
with the correct field sequence<br />
Can anyone provide me with the shortest code to do that<br />
Thank you for your help<br />
Dory<br />
<br />

</div>
</div>


Hi Guys
I have to insert an array of 6000 rows and 50 columns to an existing remote mssql table
with the correct field sequence
Can anyone provide me with the shortest code to do that
Thank you for your help
Dory



Inserting array into an mssql 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.