|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
i eve a text.txt and i want to organize it (text.txt) so that all the names must be in the name column, all the numbers must be in the number column, all the last name must be in the last name column. All the columns must be separated by a tab or a coma ( , ) . after that, the file( text.txt) as to be imported to a table every day at a certain hour ( schedualing ) automaticaly.
The sql must import the content of the file (text.txt) automaticaly every day. Last edited by mrl_sousa : November 28th, 2003 at 03:41 AM. |
|
#2
|
||||
|
||||
|
What do you mean by "organize a file"?
|
|
#3
|
|||
|
|||
|
i eve a text.txt and i want to organize it (text.txt) so that all the names must be in the name column, all the numbers must be in the number column, all the last name must be in the last name column. All the columns must be separated by a tab or a coma ( , ) . after that, the file( text.txt) as to be imported to a table every day at a certain hour ( schedualing ) automaticaly.
The sql must import the content of the file (text.txt) automaticaly every day. |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > organising and schedualing a file |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|