Import a Text File, NOT using BULK INSERT or OPENROWSET, to Sql Server - Web Server

Posted on 2009-04-15
Last Modified: 2012-06-22
Hi Experts,

I would like to import a text file, the fastest way possible, without using BULK INSERT or OPENROWSET as the SQL Server doesn't have access to the webserver for security reasons.

So. I was thinking of using something like Microsoft Text Driver to Select the Values into a DataSet and then use the DS to INSERT the values into a Table in the SQL Server?
Code Examples? I am having some issues with Text Driver and the Web Application at the moment...


Example Conn String Used

Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;

Error Returned

Data source name not found and no default driver specified

Open in new window

Question by:Craig Lambie
    LVL 12

    Accepted Solution

    LVL 1

    Author Closing Comment

    by:Craig Lambie
    Sorry I took so long to award this to you. THanks for your help...

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now