Connect between microsoft dynamic nav and microsoft access

ahmedba

I want to retrieve data from Microsoft access to dynamic nav 2009 are this possible
and how can i write code or join between each other. because i have access file database and i want to retrieve data from this table to Microsoft dynamic nav

bbrown

If you are looking to read the data and import to a NAV table, Excel Automation is one approach I've used in the past.

ahmedba

Can you clear your answer please

bbrown

What I'm referring to is the standard Excel Automation functions (Excell Buffer table) found in NAV. Since Excel can open and read a Access database, you can use this functionality to read the data and process it.

ahmedba

Now what code i can write to retrieve data and where
thanks

bbrown

Look at how the Excel Buffer table is used in the product as examples to guide you. One place is the import/export on GL Budgets. There's also lots of examples on this forum. See if that will get you started. If you have specific questions, I'll see what I can provide to assist you.

ahmedba

Now i have data to supplier in my company like this :

No Name car No weight date
12 Ahmed 12567 20kg 12/04/2012
13 Khalid 45678 34kg 12/04/2012
this data as above found in access database in table supplier and database name supplier what i need now to import these data from access to nav 2009 how i make this by automation if possible
thanks

ahmedba

Can i make this by excel buffer table in nav

bbrown

The Excel Buffer table is what I am referring to. Look at how it is used to give you some guidance. You can also search on here for lots of examples. If you get stuck then post some questions

Luc_VanDyck

If you are using a SQL database, you can use the LinkedObject-property on tables to retrieve data from an Access database: http://msdn.microsoft.com/en-us/library/dd355092.aspx