Jun 12 2017
09:52 AM
- last edited on
Jul 12 2019
10:46 AM
by
TechCommunityAP
Jun 12 2017
09:52 AM
- last edited on
Jul 12 2019
10:46 AM
by
TechCommunityAP
The old Text/CSV import wizard had not been updated since Office 2002/XP, looked old-fasioned, but it was very good at recognizing columns with dates. You could specify for instance YMD from a drop-down list and it even recognized yyyymmdd. Than suddenly, on a rainy monday morning you arrive in the office, fire up your PC, an Office 365 update comes in and without any advance notice the trustworthy old wizard is gone. Replaced by "Get and Transform Data". Great for enterprises, but a small company just needs that data that we get from the bank as a .CSV. No connections, queries, tables, transforms, styles or whatever. Just the raw data, permanently. We only need to convert that yyyymmdd dates to something Excel understands, like the old wizard did so well.
We have no time to do a course or watch video's, we need to get on with our own core business. How can we make it work again?
Jun 12 2017 10:22 AM - edited Jun 12 2017 10:28 AM
SolutionHi Willem,
Not exactly, old wizard is still here. You may add it from File->Options
Select it from Lecacy Wizards in Get data
Alternatively you may call it from Tell Me field start typing Get data from text
Jun 12 2017 10:22 AM - edited Jun 12 2017 10:28 AM
SolutionHi Willem,
Not exactly, old wizard is still here. You may add it from File->Options
Select it from Lecacy Wizards in Get data
Alternatively you may call it from Tell Me field start typing Get data from text