Retrieving Record from SQL Server 2000 table using navision

Farukca

Hi,
I wonder what is the best way to retrieve a record from a SQL Server 2000 database table with using navision tools.

I must write a codeunit that takes required records from a Sql table (for example from the employee table in Northwind database), and want to record them to a navision table;

So what is the best and fastest way to do this;

thanks...

ik

I think you should use Automation in codeunit.

'Microsoft ActiveX Data Objects 2.7 Library'.Recordset

From your codeunit you should call SQL-procedure which will do
what you need.