From: Mark Goldin on
Is it possible to create a table with columns described in a text file?

Thanks


From: TheSQLGuru on
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
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
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
>>>
>>
>>
>
>