i need to import a table Tab_Mongen and to save me typing it all out can someone tell me how to import it plz
need help with sql
- Thread starter Gough
- Start date
download the excel file of mirrealms from here
then open enterprise manager of sql.. open the mir2 db.. open tables.. right click on tbl_mogen and select all activities.. import data..
then when the window pop ups press next
data source must be set to microsoft excel 4.0
filename must be the excel file u downloaded
then next
then next again
select copy tables and press next
enlarge the source field to see the complete names of the tables.. one should be tbl_mogen$ and the other tbl_mogen$data.. select the first one
under the destination voice press the arrow down and choose [mir2].[dbo].[TBL_MONGEN]
in the transform voice press the ... and in the new window that pops up select
"Create destination table" and "drop and recreate destination table" then press OK
then press next and next again.. it should delete the table and recreate it with the new info in..
then open enterprise manager of sql.. open the mir2 db.. open tables.. right click on tbl_mogen and select all activities.. import data..
then when the window pop ups press next
data source must be set to microsoft excel 4.0
filename must be the excel file u downloaded
then next
then next again
select copy tables and press next
enlarge the source field to see the complete names of the tables.. one should be tbl_mogen$ and the other tbl_mogen$data.. select the first one
under the destination voice press the arrow down and choose [mir2].[dbo].[TBL_MONGEN]
in the transform voice press the ... and in the new window that pops up select
"Create destination table" and "drop and recreate destination table" then press OK
then press next and next again.. it should delete the table and recreate it with the new info in..
Upvote
0