Updating data using import wizard in SQL Server error

Jinal Contractor 121 Reputation points
2023-05-12T18:59:40.9766667+00:00

I'm trying to import data from Excel to SQL DB using import wizard but getting an error on one of the column. Even I tried to create table first and then import data still no luck.

I've one column name Extdesc which is contain 468 characters on it and import wizard auto taking nvarchar(255) is there way I can upload full description of that column in other way without cut of words from excel? If so please guide me how can I import correctly excel file?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,080 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Naomi 7,361 Reputation points
    2023-05-12T19:21:55.3466667+00:00

    Did you try to create a table in advance with a big enough column?


  2. Guoxiong 8,126 Reputation points
    2023-05-12T22:04:08.8666667+00:00

    You can edit the column mappings. See the following screenshot:

    User's image

    0 comments No comments

  3. Olaf Helper 42,486 Reputation points
    2023-05-15T06:01:04.14+00:00

    import wizard auto taking nvarchar(255)

    That's the default for Excel column data and the data provide JET/ACE don't support large data then 255 chars.

    0 comments No comments