OLE DB or ODBC error: Type mismatch.

[Anonymous]

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

[Greg_Deckler]

@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?