Answered by:
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.
- Moved by SamAgain Monday, July 12, 2010 8:25 AM better fit (From:.NET Base Class Library)
Monday, July 12, 2010 4:15 AM
Answers
-
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- Proposed as answer by Dev-FX Tuesday, July 13, 2010 1:45 PM
- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Monday, July 12, 2010 10:42 AM -
Hi,
Another interesting document : http://msdn.microsoft.com/en-us/library/aa173839%28SQL.80%29.aspx
Thanks.
- Proposed as answer by Dev-FX Tuesday, July 13, 2010 1:45 PM
- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Tuesday, July 13, 2010 1:45 PM -
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)- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Wednesday, July 14, 2010 12:13 PM
All replies
-
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- Proposed as answer by Dev-FX Tuesday, July 13, 2010 1:45 PM
- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Monday, July 12, 2010 10:42 AM -
Hi,
Another interesting document : http://msdn.microsoft.com/en-us/library/aa173839%28SQL.80%29.aspx
Thanks.
- Proposed as answer by Dev-FX Tuesday, July 13, 2010 1:45 PM
- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Tuesday, July 13, 2010 1:45 PM -
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)- Marked as answer by Michael Sun [MSFT]Microsoft employee Monday, July 19, 2010 10:09 AM
Wednesday, July 14, 2010 12:13 PM