Hi, Would be best to insert something you can reference as NULL, i.e. 'NA'. Then each line in your text file with 'NA' could be filtered as NULL. If you use my Coop search tools below you will find examples of what you are looking for. Salute, Mark Technical Evangelist for DiscountASP.NET Find ASP.NET code samples with my Dev Coop search tools below. Google Microsoft DiscountASP.NET Technical Webcasts: http://www.iis7test.com/webcasts/ My Microsoft Technical Blogs http://weblogs.asp.net/markwisecarver/ http://blogs.windowsclient.net/wisecarver/default.aspx
Hi Thanks for reply. Is it ok if it ok if i consider 'NA' for column of types int and varchar? I will try it. Thanks for quick reply
Hi i am trying to write NULL values in to .txt file and i should be able to insert same NULL while reading from .txt file. any help
