Share via

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.
14,494 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Naomi Nosonovsky 8,331 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,206 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
  3. Olaf Helper 46,546 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.