Share via

how do I fix the Import and Export wizard so that I can use Fixed Width columns

Brandon Kruger 0 Reputation points
2024-09-06T15:35:51.8766667+00:00

When using the Import and Export Wizard for SQL Server Management Studio if I try to import a flat file that has a fixed width the application will not let me view the column or fix the width of the columns. image attached. I have tried full screen and the size of the text does not change. as you can see in the screen shot words are also cut off. User's image

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,818 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,206 Reputation points Microsoft Vendor
    2024-09-09T03:05:20.74+00:00

    Hi @ Brandon Kruger

    Did you select "Fixed width" as the file format in general tag? You can also define the column widths and other formatting options.

    User's image

    In addition, you can try to use Import Flat File to SQL Wizard in SSMS. The Import Flat File Wizard supports both comma-separated and fixed width format files. Refer to MS document Import Flat File to SQL Wizard for reference.

    9-9-1

    If the answer is helpful, please click "Accept Answer" and kindly upvote it.

    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.