• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • Last Modified:

Inserting array into an mssql table

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

0
dory550
Asked:
dory550
1 Solution
 
imran_fastCommented:
What is the format for your source?
Is it a text file?
Then use DTS.
0
 
dory550Author Commented:
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
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now