Create table from file
in [Programming SQL]
|
From: Mark Goldin on 4 Apr 2007 15:23 Is it possible to create a table with columns described in a text file? Thanks
From: TheSQLGuru on 4 Apr 2007 16:47 Sorry, need more information than this to help out! -- TheSQLGuru President Indicium Resources, Inc. "Mark Goldin" <mgoldin(a)ufandd.com> wrote in message news:%23Heau6udHHA.1312(a)TK2MSFTNGP03.phx.gbl... > Is it possible to create a table with columns described in a text file? > > Thanks >
From: Mark Goldin on 4 Apr 2007 17:01 I have a text file with columns names. There are too many columns to type into CREATE TABLE statement. Structure comes from mainframe computer. I was thinking to "make" CREATE statement getting columns info from fille. "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message news:%23pQDEqvdHHA.1216(a)TK2MSFTNGP03.phx.gbl... > Sorry, need more information than this to help out! > > -- > TheSQLGuru > President > Indicium Resources, Inc. > > "Mark Goldin" <mgoldin(a)ufandd.com> wrote in message > news:%23Heau6udHHA.1312(a)TK2MSFTNGP03.phx.gbl... >> Is it possible to create a table with columns described in a text file? >> >> Thanks >> > >
From: Hari Prasad on 5 Apr 2007 00:11 Hello, Best method is create the table and define data types manually. Try using DTS or SQL Server Integration Services data import wizard. That will allow you to create the table based on the text file . Thanks Hari "Mark Goldin" <mgoldin(a)ufandd.com> wrote in message news:Ox5JbxvdHHA.1220(a)TK2MSFTNGP03.phx.gbl... >I have a text file with columns names. > There are too many columns to type into CREATE TABLE statement. Structure > comes from mainframe computer. > I was thinking to "make" CREATE statement getting columns info from fille. > > "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message > news:%23pQDEqvdHHA.1216(a)TK2MSFTNGP03.phx.gbl... >> Sorry, need more information than this to help out! >> >> -- >> TheSQLGuru >> President >> Indicium Resources, Inc. >> >> "Mark Goldin" <mgoldin(a)ufandd.com> wrote in message >> news:%23Heau6udHHA.1312(a)TK2MSFTNGP03.phx.gbl... >>> Is it possible to create a table with columns described in a text file? >>> >>> Thanks >>> >> >> > >
|
Pages: 1 Prev: generated insert, update and delete Next: CLR Store Proc OleDbPermissions to an AS400 |