Importing an excel file to SQL-Server Tables

Hi All
Iam planning to import an Excel file into a SQL Table. In one of the colums
the data is like '123dsfgf' and it is taking as NULLS when I import into sql
Table. where as the value like '123454' is working fine.
Any Ideas please
THanks
Open up your excel spreadsheet, highlight this column, right click and
select format cells. In the number tab, select Text for this Column.
Reimport the spreadsheet.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"TZ" <TZ@.discussions.microsoft.com> wrote in message
news:7BEC7751-CBA0-45D4-AF3B-0B1F58735B1C@.microsoft.com...
> Hi All
> Iam planning to import an Excel file into a SQL Table. In one of the
colums
> the data is like '123dsfgf' and it is taking as NULLS when I import into
sql
> Table. where as the value like '123454' is working fine.
> Any Ideas please
> --
> THanks
|||Hilary,
I tried as u had mentioned and still it is not working
"Hilary Cotter" wrote:

> Open up your excel spreadsheet, highlight this column, right click and
> select format cells. In the number tab, select Text for this Column.
> Reimport the spreadsheet.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
>
> "TZ" <TZ@.discussions.microsoft.com> wrote in message
> news:7BEC7751-CBA0-45D4-AF3B-0B1F58735B1C@.microsoft.com...
> colums
> sql
>
>
|||post this to the SQL DTS newsgroup.
"TZ" <TZ@.discussions.microsoft.com> wrote in message
news:853F8FB5-04D6-4692-A625-04AC4F53BCD0@.microsoft.com...[vbcol=seagreen]
> Hilary,
> I tried as u had mentioned and still it is not working
> "Hilary Cotter" wrote: