How to upload a DAT file in sql server 2000?

Question

Hi,

 

        I want to know how to upload the DAT file in sql server 2000 using vb.net. Thanks in advance.

Answer 1

There are multiple options to do that. There are some examples here

http://www.mssqltips.com/tip.asp?tip=1207

One more way is to use SqlBulkCopy .NET class

http://www.sqlteam.com/article/use-sqlbulkcopy-to-quickly-load-data-from-your-client-to-sql-server

---

Val Mazur (MVP) http://www.xporttools.net

Answer 2

Hi,

Another interesting document : http://msdn.microsoft.com/en-us/library/aa173839%28SQL.80%29.aspx

Thanks.

Answer 3

We would need to know the format of the file. There is no standard DAT file format, however; the SQLBulkCopy method that Val mentioned would be applicable if you could read the file into a DataTable or through a DataReader.

---

Paul ~~~~ Microsoft MVP (Visual Basic)