I have a rather large csv file (5M records). When I go to load it I do so by clicking "Only Create Connection" and checking the box " ADD the data to the Data Model". Next I filter the data, etc. This results in a file much smaller that excel can handle. I then want to Load & Close to a Table. However, that option is not available. The question is: How do I load the resultant file to a table?
Hi Harry,
You have to change the Load To settings. From the Excel worksheet open the queries pane > right-click the query > Load To. Deselect the 'Only create a connection' and choose 'Table'. The 'Add this to the Data Model should also be checked.
Note: only the filtered data will be in the data model.
If you want the data model to have all 5M records but the Excel Table to only contain the filtered list then you'll need to create two queries. The second query, for theExcel Table, can 'Reference' the first query.
Let me know if you get stuck.
Mynda
Got it. Thank you!
