Help me please

[BadBoy]

Hi all

can you help me to copy TBL_MONGEN.TXT from txt file to SQL data base in one time becuse i will waste my time to copy txt file information to SQL database Table File (1x1)

thanks all

 

[excluded]

Hi all

can you help me to copy TBL_MONGEN.TXT from txt file to SQL data base in one time becuse i will waste my time to copy txt file information to SQL database Table File (1x1)

thanks all

i didnt think it an be done by .txt file -- think Excel is needed to do more then 1x1 , i may be wrong cuz i never tried with a .txt file

 

[Andreas]

it can be done but i cant remeber how
try use the search button badboy

 

[mStation]

open sql enterprise manager
open microsoft sql servers
open sql server groups
open local
open databases
open mir2
select tables
scroll down until you selet tbl_mongen
right click on it and choose all activities -> import data
press next
choose for data source -> text file and press the [...] button to choose the file txt contaning the mongen
press next
choose delimited and press next, choose what character delimites the values into your file txt.. usual it is comma then press next
then choose the correct table you want to import to and then create and drop the old them using the advanced options..
and end the import


probably i will make a video for this.. so you will get it right immediately

exporting a table to a txt file:
http://www.megaupload.com/?d=N25JTGG0

importing a txt to a table:
http://www.megaupload.com/?d=4X1WJHWR