Updating Data in Excel

If you are using Excel, it is also possible to make your changes there, and then import the CSV to update the Final tables in Sage X3.

To update data using Excel:

In DataSync, run Extraction 4 ( created in Importing the Extractions to export data to CSV.
1. Select the extraction from the list and click the Run Extraction Now icon.
2. Click Run.
Open the CSV file in Excel and fix the data.
In DataSync, run Extraction 5 to import the CSV and update the Final tables.
1. Select the extraction from the list and click the Run Extraction Now icon.
2. Click Run.

Did this topic answer all your questions?
Yes No

Sorry about that

Why wasn't this helpful? (check all that apply)

I couldn't find what I was looking for

The instructions were confusing or unclear

The instructions didn't work

Thank you for your feedback.

Would you like to give us more details on this?

Send your feedback to our documentation team.

Great!

Thanks for taking the time to give us some feedback.