Bulk Insert

smoochy boys on tour

norwayrules

Dedicated Member
Dedicated Member
Mar 12, 2010
49
0
32
Anyone knows how to use Bulk Insert to transfer a text file mongen table to sql 05?
ty
 

norwayrules

Dedicated Member
Dedicated Member
Mar 12, 2010
49
0
32
kk i have open this http://www.forum.bandet.org.uk/uploa...oringdbsql.doc and all in there is numbers and words i dont understand beside this sentince See Next Screenshot

Click Overwrite the existing Database. Then Click OK.


You will see executing on the bottom left hand side of the screen. You should then see the database has been completed successfully

and i know how to restore a database i have follow the thread to make a server from mstation and useing 2.3 files add by thedeath.
so fare so good but the mongen table is not complete and some other items but what is important that i need a euro mir mongen table.

if you could explain abit more with be greatful ty


and btw bulk insert is the same ways as useing dts wizard to import tables but her you write down codes in the sql server qurey.
 
Last edited:
Upvote 0

wanabee

Golden Oldie
Golden Oldie
Jul 10, 2004
723
4
125
newbury
kk i have open this http://www.forum.bandet.org.uk/uploa...oringdbsql.doc and all in there is numbers and words i dont understand beside this sentince See Next Screenshot

Click Overwrite the existing Database. Then Click OK.


You will see executing on the bottom left hand side of the screen. You should then see the database has been completed successfully

and i know how to restore a database i have follow the thread to make a server from mstation and useing 2.3 files add by thedeath.
so fare so good but the mongen table is not complete and some other items but what is important that i need a euro mir mongen table.

if you could explain abit more with be greatful ty


and btw bulk insert is the same ways as useing dts wizard to import tables but her you write down codes in the sql server qurey.

try following this guide http://www.forum.bandet.org.uk/uploadsystem/uploads/importexportDTS.doc if the mongen is not complete and someone has not posted one you will need to find the cords of the doors and enter them in the movemap file. if the mongen is not complete you will have to add this yourself use microsoft access to add the things you require then import that to sql as is stated in the guide.

all the help i can give.
 
Upvote 0