Solved

To Create Formatfile.

Posted on 2006-06-13
6
367 Views
Last Modified: 2008-01-09
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
Comment
Question by:Mateen
  • 5
6 Comments
 
LVL 4

Accepted Solution

by:
batchakamal earned 250 total points
ID: 16900154
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
 
LVL 4

Expert Comment

by:batchakamal
ID: 16900165
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
 
LVL 4

Expert Comment

by:batchakamal
ID: 16900172
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 16900173
read this on  bol

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

Expert Comment

by:batchakamal
ID: 16900189

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
 
LVL 4

Expert Comment

by:batchakamal
ID: 16900191

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

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question