sql server - Migrate Excel Data to SQL -


i have large table of information (around 11,000 rows, 4 columns) in excel uses macro , need import sql server, microsoft sql server management studio, utilized server new information.

example: if type sql:

insert ent_link_objects (obj_name, entity_key, identity_key) select 'tds-c1487-81236', item_key, 1 ent_item_master m m.item_code = 'tl-123' or m.item_code = 'tl-456' 

i can open program holds information, called matrix, prompts me enter item key and/or code and/or type etc (which has possible files listed below it) , hit search (image 1). if type in tl-123 item code section (image 2), narrows down files containing tl-123 (image 3). when double click, can click on many tabs, 1 of "links". in tab under document name information tds-c1487-81236(image 4). how go making happen?

(1)

enter image description here

(2)

enter image description here

then hit enter

(3)

enter image description here

(4)

enter image description here

the website below explanation of getting @ not know how implement it. efficient way migrate data excel document sql server?

http://sqlmag.com/business-intelligence/excel-macro-creates-insert-statements-easy-data-migration

create linked server or use statement openrowset access excel sheet. easiest , fastest method of accessing excel sheet via sql.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -