Why Does DBeaver Fail to Import CSV into SQL Server? A Step‑by‑Step Fix

1. Introduction

In a recent Python community discussion, a user encountered an error when importing a CSV file into SQL Server using DBeaver: "Can't parse numeric value [B02010ZZZ] using formatter".

2. Implementation Process

A community member pointed out that the error occurs because the value B02010ZZZ cannot be converted to a numeric type, suggesting to verify that the import targets the same table and that column data types match.

Another participant noted that importing the same CSV into SQLite succeeded, indicating the issue is specific to SQL Server column definitions.

The solution is to check the column type settings before import and ensure they align with the data being loaded.

Further screenshots from the user showed mismatched data types between two import attempts, confirming the root cause.

After correcting the column definitions, the import succeeded without errors.

3. Summary

The article details a DBeaver CSV‑to‑SQL Server import error caused by inconsistent column data types, provides diagnostic steps, and demonstrates how adjusting the column definitions resolves the issue.