Importing data

underprocessableIt's hard to manage a table having 700 columns. Better break it up into
tables of manageable size before importation.
Martin C K Poon
Senior Analyst Programmer
====================================
"someone" <someone@.spamwhere.com> bl
news:eQpAZckhGHA.764@.TK2MSFTNGP03.phx.gbl g...
> Hi all,
> I am having hard time trying to import data from a dbf file into a Sql
> table. The dbf file has 700 columns. I tried using DTS, the OPENROWSET,
etc.
> Nothing works for me. Any idea how I can import such a large file into
Sql.
> I am attaching a sample dbf file.
> Thanks in advance...
>
>|||Thanks. I know that. I don't manage this table; this is one of our client's
table. I only know Sql Server. I am hired to migrate this table to Sql and
break it up. But first I need to import it to Sql Server!
"Martin C K Poon" < martinpoon__at__graduate__dot__hku__dot_
_hk> wrote in
message news:ufYI8QwhGHA.4896@.TK2MSFTNGP05.phx.gbl...
> It's hard to manage a table having 700 columns. Better break it up into
> tables of manageable size before importation.
> --
> Martin C K Poon
> Senior Analyst Programmer
> ====================================
> "someone" <someone@.spamwhere.com> bl
> news:eQpAZckhGHA.764@.TK2MSFTNGP03.phx.gbl g...
> etc.
> Sql.
>