Use VBA to import CSV file to PowerQuery Data Model

**varundutta10** · 06-19-2019, 08:43 AM

Hi,
I wanted to import .csv file to PowerQuery Data model. I don't want to render the .csv data onto the excel sheets as its more than 10 lakhs + i want to perform more operations on the csv data. Can anyone help me with the same?

**CK76** · 06-19-2019, 09:01 AM

? You don't need VBA, nor do you have to load the data to sheets.

Just use PowerQuery -> From File -> From Text/CSV. You can perform transformations within PowerQuery Editor. Then instead of loading to sheet, set it to load to Data model.

Then you can use Pivot Table to summarize data.

Use VBA to import CSV file to PowerQuery Data Model

LinkBack

Thread Tools

Rate This Thread

Display

Use VBA to import CSV file to PowerQuery Data Model

Re: Use VBA to import CSV file to PowerQuery Data Model

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using PowerQuery(2013) to Access and Update Sharepoint File

Import CSV to Data Model - Change decimal separator

Data Import does not add to data model

Office 2010 Data import from other exel file will open the source file, Why?

[SOLVED] MACRO: Store name of selected file as string w/ import data file dialog box

[SOLVED] Macro - Master file to import data from another open file with variable file name

[SOLVED] How do I import text file, analyze data, export results, open next file

Bookmarks

Bookmarks

Posting Permissions