how can i import data from excel file to Database table by using data migration

Business Central/NAV User Forum
1

Hi,

I am using NAV2013.

Actually I have excel file with data and i have to import this data to the table but by data migration, so any one can tell me about

Data migration process. That table i also just created.

Thanks in advanced[:D]

2

Look at the folllowing link

http://msdn.microsoft.com/en-us/library/hh179459(v=nav.70).aspx

3

You need to select the table in data migration, select the required fields & use export to excel.

Fill the excel sheet created and then import the excel sheet from data migration function itself.

4

Data Migration functionality is not available in NAV2013.

Its called Rapid Start Services.

Have a look at this video for basic idea…

http://mohana-dynamicsnav.blogspot.in/2013/04/how-to-import-and-post-opening-balances.html