Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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

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

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Anonymous

     

    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,

     

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Anonymous

     

    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,