
November 25th, 2003, 09:37 AM
|
|
Junior Member
|
|
Join Date: Oct 2003
Location: mozambique
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
organising and schedualing a file
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.
|