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)
(2)
then hit enter
(3)
(4)
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
Post a Comment