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?

Thanks!

Ian

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

Answers

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