How to get data from Excel into a SQL table

xenonxenon Member Posts: 30
Hello everyone.

I have an Excel spreadsheet with a few thousand items in there with the weight - just two columns. What I want to do is for each "Item" in the spreadsheet column "A" get the weight from column "B" and populate the weight field in my Item table in SQL.

Can anyone show me a script by which I could achieve this?



PS - this is NAV2009R2 so I guess a dataport would work too but I'm not a NAV developer and I don't have a developer licence.

Best Answer


  • xenonxenon Member Posts: 30
Sign In or Register to comment.