Inserting data from file

  • Hi, I'm trying to do a Procedure where I take a text block and I insert it on a specified table.

    The problems begins when I need to put ' or delete it on each value depending from the data type of each field.

    How Could do it?

    thanks.

  • You're going to need to be a lot more specific. I suggest you start by reading Forum Etiquette: How to post data/code on a forum to get the best help.

    [/url]

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • You might also want to check the following article about importing flat files into SQL Server.

    http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply