[SOLVED] How do you import .DAT file into SQL Server?

#1 (**permalink**) 06-10-2007, 05:41 PM

How do I do it?

#2 (**permalink**) 06-10-2007, 05:42 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode