Data Import with BCP

  • All,

    I have 100 files in a folder on my local computer. I would like to import data from all those files with name ending "_Final" to my sql server table using BCP. I can not use bulk insert as the data is on my pc and dont have access to server.

    So if there are 30 such files with this name then the data from only those 30 files to go to table.

    any help appriciated.

  • Please don't cross post. Same question (to be used for further assitance) asked here .



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • Sure... I won't.. I actually didnt find the option to remove that...

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

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