Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

OLE DB or ODBC error: Type mismatch.

Hello

 

I use the following to insert an empty row in a table regardless of the columns it may have:

 

= Table.InsertRows(#"Replaced Value", 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(#"Replaced Value")),Table.ColumnNames(#"Replaced Value"))})

 

However, I get the error:

OLE DB or ODBC error: Type mismatch.

 

Any idea how to fix that? 

 

Thanks

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Looks like you are trying to replace text in a numeric field or vice versa so maybe a Change Type step before this step?