Database

View All Threads First Prev Next

Importing of Huge fixed width text file in sql server table ibrahim sharief27-Dec-12 9:24 ibrahim sharief 27-Dec-12 9:24  I am learning Asp.net with C# and Sql server. I came across with a huge fixed width text file of 1780 columns. I have to import this file in sql server table. I will appreciate if you can help in this. Thanks Ibrahim Sharief isharief291@gmail.com Re: Importing of Huge fixed width text file in sql server table PIEBALDconsult27-Dec-12 14:08 PIEBALDconsult 27-Dec-12 14:08  Look into bcp[^]. Re: Importing of Huge fixed width text file in sql server table Deepak Kr130-Dec-12 20:29 Deepak Kr1 30-Dec-12 20:29  Use Data Import Export Wizard of Sql Server Re: Importing of Huge fixed width text file in sql server table jschell31-Dec-12 9:14 jschell 31-Dec-12 9:14  Besides just importing it you might want to consider if you really want to have a table with that many columns.

Last Visit: 31-Dec-99 18:00     Last Update: 24-Apr-24 14:22 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.