Mateen
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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.