Automatic importing of a file

  • I've written a procedure to match data supplied by a client to our databases.  The client need only specify their relevant field names and away it goes.

    The issue I have at the moment is the procedure I need to write before that.  Namely grab the client file and import their data into SQL.  The field names are irrelevant as the program will take the 1st record as header.  Also field lengths and types have been dealt with.

    If it helps I'm only taking csvs.  Any help would be greatly appreciated.

  • The best thing you can do is to get the users to save their files in the same folder each time. You can then cycle through all the files in the folder doing your imports. See this link that shows you how to do it. I used this solution and it's very weel written and easy to follow:

    http://www.databasejournal.com/features/mssql/article.php/1461661

     


    ------------------------------
    The Users are always right - when I'm not wrong!

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

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