Import of EXCEL/ ACCESS-data

Hello, I’m rather new with NAVISION. I know I can export data from NAVISION to EXCEL by ODBC. But how can I import data from EXCEL/ ACCESS into my NAVISION-system ?? For example: we sell more than 1000 articles. These articles are in an EXCEL-file with columnnames Articleno., Description, Costprice, Price for sale, supplier. All our resources( 200 ) are in a ACCESS-database. How to integrate this in NAVISION ? Also with ODBC ?? Regards, NOORT21[:(]

Hi! With C/ODBC other Programs could access the NAVISION-database. If NAVISION should acces another database - e.g. Access - you could do this by “Excel-” or “Access-Automation” or “Microsoft ActiveX Data Objects” (MS ADO). Just search MBSUG for “Excel Automation” or “MS ADO” and you’ll find some postings and examples to this! Regards, Jörg

Hi again! Of course you also can transfer data via ASCII-files …

Exactly. The easiest way is to, export the data in csv format (from Excel / Access) and then write dataports in Navision to import the data. And although AUTOMATION in theory is a good idea, it’s not as simple as it sounds and it can cause other problems. So stick to the csv - dataport option.

I love this! High-End-Computer, UptoDate - Software with many features, fully automated production sites, airplanes flight by computers etc. but if you want transfer data from one program to another go back to ASCII [:D][:D][:D]. bye André

Noort, look at te already posted messages. You can find how to import from Access and Excell.

Well… it also depends on how much data you’re having to import. When working with big text files, navision’s performance it’s not as good as it should when importing data, making the process sometimes terribly slow unless you divide the file in smaller ones… A not really difficult way to do it it’s using ADO with the access database, and importing the excel data into a new table in Access using the standard import data process included in access, then, import to navision with automation. Advantages on using text files: Usually faster and easier to develop. Disadvantages on using text files: On big files, importing a text file it’s slower (sometimes terribly slower) than using automation with an access database, where the speed it’s almost constant no matter how much data you’re having in the database. If you use special characters like single or double quotes on codes and descriptions the dataport it’s not as reliable and easy as importing the data using ADO. Regards,

Hey there ! I had something similar to accomplish. Import data into Navision from Excel. I just reversed the Excel automation : CREATE(xlApp); xlBook := xlApp.Workbooks.Open(’\myserver\myexcel.xls’); xlsheet := xlApp.ActiveSheet; xlBook.RefreshAll; //to get Data from mySQL via ODBC first IF “mytable”.FIND(’-’) THEN BEGIN z:= 1; REPEAT z:= z + 1; “mytable”.myfield1 := FORMAT(z); “mytable”.myfield2 := FORMAT(xlsheet.Range(‘A’+ FORMAT(z)).Value); “mytable”.myfield3 := FORMAT(xlsheet.Range(‘B’+ FORMAT(z)).Value); //and so on… Excel-end := FORMAT(xlsheet.Range(‘x’+ FORMAT(z)).Value); //to get an ending point of Excel, otherwise Navison will go on and on “mytable”.INSERT; “mytable”.NEXT; UNTIL Excel-end = ‘’; END; CLEAR(xlApp); CLEAR(z); Bye, Christian

Most easy way to export/import data to/from Excel is to use system table 370 Excel Buffer. There are functions that will do all this for you! Have a Nice Day!

Hi I too am new to Navsision but have just imported all customers, suppliers and chart of accounts and am now working on importing stock… I simply wrote dataports to import this information from a csv file (again greated in XLS). All records were updated correctly and it was very simple to use… Good Luck