Change source file for input data from Excel worksheet to Access table (same column structure)

[CloudMonkey]

Hi,

Please can you tell me how to change the data source target from the Excel file to the Access table?

I've seen some threads on changing excel worksheet sources using "Advaned Editor" but I don't see how to change from excel worksheet to access table (my columns in both are in the same order/structure)

Thanks,

CM

[v-sihou-msft · Accepted solution]

@CloudMonkey

Connecting Excel and Access are calling different functions in Power Query. You need to replace the entire Source part in Power Query. And you need to add a step to transform data type for columns when connecting Excel file. You can compare below Power Query for these two sources.

For more details, please refer to: Accessing data functions

Regards,