Post reply

importing data from a flat file

  • March 12, 2009 at 3:17 am

    #135495

    How do we import data from a flat file to the SQL server 2005. the files are on the c: local machine and it is a big file it can open with the note pad.it does have the delimeter (~||). and it is my first time to use the 2005 version I have been using the 2000 version and it was fine. since we upgraded, I am having difficulty.

  • March 12, 2009 at 6:15 am

    #958244

    Same as, Link.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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