Forum Discussion
Simplify csv import export workflow
I'd like to simplify the workflow to importing data from a service I subscribe to into my database. I've been employing the following steps. The first step is exporting data from my source. When...
Hello,
For this kind of tasks it is better to use power query. You set up the system once and then the whole procedure becomes automatic. You can also set the query to get the last file in a directory so that whenever you copy the new .csv file, the query will automatically takes it and updates all the data. The only thing you need to do would be usins save as dialog.
For this kind of tasks it is better to use power query. You set up the system once and then the whole procedure becomes automatic. You can also set the query to get the last file in a directory so that whenever you copy the new .csv file, the query will automatically takes it and updates all the data. The only thing you need to do would be usins save as dialog.
Thanks erol sinan zorlu,
Can you suggest a source that provides instructions on how to achieve that?
Afraid that won't work on Excel for Mac, Power Query has quite limited functionality for it.
- Thanks
A_Castro1625 Since you indicated that you work on a Mac, you may forget about using Power Query.
- Thanks. Glad you told me that before I invested the time into it.
- For a basic study you can get M for Data Monkey book. For advanced applications it is up to you.
