Excel file import to Sql Server problem

3 Dec 2005 12:13 AM

GB

Hello:
I need to import an Excel file to SQL Server.
The .xls file has the column names which contains
dot inside, like AAA.BBB. When I import this file
in SQL using DTS Import/Export tool, it creates a table
with column names like AAA#BBB.
So, during import process the dots substitutes with #.
Could you, please, give me a hint how to fix the problem?

Thanks,
GB

15 Dec 2005 7:52 AM

Prashant D.

Hi GB
While using DTS,
after selection of "Copy Table(s) and view(s) from the source database",
click on NEXT will result in grid,
and complete DTS execution. This will result in creation of empty table with
.. in column names but data importing will fail at this time.

Now re-run the DTS to import data into existing table from same excel file
withany problems. It works...

Prashant Deshmukh

Show quote

"GB" wrote:

> Hello:
> I need to import an Excel file to SQL Server.
> The .xls file has the column names which contains
> dot inside, like AAA.BBB. When I import this file
> in SQL using DTS Import/Export tool, it creates a table
> with column names like AAA#BBB.
> So, during import process the dots substitutes with #.
> Could you, please, give me a hint how to fix the problem?
>
> Thanks,
> GB
>
>
>