Hi! I have a problem. I have this excel spreadsheet with over 2K rows.
I need to update a price list in SQL / Great Plains Dynamics. The table is IV00108
Current the table has item number, item description, and four (4) price levels:
1-9, 10-49, 50-99, 100+
The excel spreadsheet i have - has the item number, item description, and four (4) NEW price levels:
1-10, 11-50, 51-100, 101+
Is there any easy way to do this? Should I do it thru SQL Management Studio 2012 and how? Should I do it thru integration manager and how?
I am a noob and trying to learn. If ANYONE can help I would be appreciative!!!