Thread: [SOLVED] How do you import .DAT file into SQL Server?
View Single Post
  #2 (permalink)  
Old 06-10-2007, 05:42 PM
Solly
Posts: n/a
Open the .DAT file with Notepad or some other text editor, and determine how the records are laid out - tab delimited, comma delimited, fixed field, etc. Once you understand how your data is formatted in the .DAT file, you can import the .DAT file using DTS in SQL Server. The import wizard in the DTS utility is pretty self explanatory.

__________________
Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!