Import SQL Server data to a DAT file

[gauthambr83]

Hi all,

I want to know how to import SQL Server(2005) data into a DAT file. Can anyone help me on this.

[Shashi Sadasivan]

Hi all,

I want to know how to import SQL Server(2005) data into a DAT file. Can anyone help me on this.

Do you want to import a dat file into SQL server or export data from a sql database to a .dat file?

a .Dat file is generally a csv file, and that can be produced using Sql Server (I dont think it is possible to do it with Sql Server Express)

in the import options choose a flat file for import/export depending upon your need

[gauthambr83]

Sorry! I want to export sql server data into a DAT file.

[Shashi Sadasivan]

In SQl Server management studio, right click the database
and choose Tasks -> Export data

choose the source data and select the database from which you want to export any tables

in the next windows which is the destination
instead of SQl Native client choose flat file Destination
put in a filename .dat

this file will be in the format of a csv file

follow the steps and you should be able to export it

[gauthambr83]

In SQl Server management studio, right click the database
and choose Tasks -> Export data

choose the source data and select the database from which you want to export any tables

in the next windows which is the destination
instead of SQl Native client choose flat file Destination
put in a filename .dat

this file will be in the format of a csv file

follow the steps and you should be able to export it

Hi Shashi,

Job done, thanks for your help.