• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

To Create Formatfile.

SQL2K

How to create a formatfile.

Suppose I want to create a format file C:\Mateen.fmt

If
ServerName:    sdmsrv
UserName   :    sa
Password    :    xyz

then what would be the exact syntax.

Actually I have read the help file, but I am unable to design errorfree syntax.
0
Mateen
Asked:
Mateen
  • 5
2 Solutions
 
batchakamalCommented:
It is nothing to do with ur server name, user name and password.

1. It is a text file with .fmt extension.
2. This is used to import the data from a text file to a table, with the format specified in the format file.
3. This is used with BULK INSERT

Put some lines of data sample and table syntax. Then I can write you the error free format file.

0
 
batchakamalCommented:
It is nothing to do with the user name , server name and password.

1. Format file is used with BULK INSERT statement, to import a data file into a table.
2. This can be created using Notepad with .fmt extension
3. If you put some sample data and the table syntax, then we can help you in designing the format file without errors.
0
 
batchakamalCommented:
It is nothing to do with the user name , server name and password.

1. Format file is used with BULK INSERT statement, to import a data file into a table.
2. This can be created using Notepad with .fmt extension
3. If you put some sample data and the table syntax, then we can help you in designing the format file without errors.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Aneesh RetnakaranDatabase AdministratorCommented:
read this on  bol

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_impt_bcp_9yat.htm
0
 
batchakamalCommented:

It is nothing to do with the user name , server name and password.

1. Format file is used with BULK INSERT statement, to import a data file into a table.
2. This can be created using Notepad with .fmt extension
3. If you put some sample data and the table syntax, then we can help you in designing the format file without errors.
0
 
batchakamalCommented:

It is nothing to do with the user name , server name and password.

1. Format file is used with BULK INSERT statement, to import a data file into a table.
2. This can be created using Notepad with .fmt extension
3. If you put some sample data and the table syntax, then we can help you in designing the format file without errors.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now