![]() ![]() Mark the reply as an answer if you find it is helpful. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. I suggest you go to MSDN forum to ask this question. If you want to know if Macro or scripting can get your result. I also tried to create link between XML file and Excel file, unfortunately I also didn't get the result. ![]() In the Get External Data section press the From File button. Now we will set up the import query for one file. The first thing that i'm doing is :configuration worksheet->i choose customer then i export to template -> i fill the excel file -> i selected customer and i click on import from template. Step 1: Setting up the import query for one file. Only the data is different for each file. I tested your problem in my environment, I found if I modified the data in Excel then I save the file as XML format and covert the original file it's OK.Īs you said when you modified the data in Excel and the original source file also update to the latest data. The data is in a sheet called Sheet1 for each file.
0 Comments
Leave a Reply. |