Import Access Database

DyNav4
DyNav4 Member Posts: 8
edited 2006-12-19 in NAV/Navision Classic Client
Hello Forum,

i want to import a table from a "MS Access" database, which contains 1 Memofield. In some records in the memofield there are more than 1024 Characters (i want to convert this memofield into multiple lines in the comment table within Navision).

Could you give me some tips, how to do this (via XML, XLS, DBF, ADO, TXT,...??)

Best regards

DyNav4

Comments

  • themave
    themave Member Posts: 1,058
    If you just want to get it done quickly, take the simple route

    add another field to the access database, memo2, use an update query to parse your text between the first and second field and then export the access database twice, once with the memo1 line and a second time using the memo2 field. The dataport in Navision will be the same, as it will just be something like,

    primary key
    memo field

Categories