Importing Data from Excel file

#1

Hi All,
I'm importing data from an Excel file, it works fine but when data
like 32/40 comes it insert null into database, eventhough i declare datatype
of column as varchar.
I'm insisting for suggestion, is there any way by which we can import single
column from excel file into single column of database

#2

Try converting the data in Excel to text first

http://sqlservercode.blogspot.com/

"Manish Sukhija" wrote:

Quote:

Hi All,
I'm importing data from an Excel file, it works fine but when data
like 32/40 comes it insert null into database, eventhough i declare datatype
of column as varchar.
I'm insisting for suggestion, is there any way by which we can import single
column from excel file into single column of database

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Importing Data from Excel file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Importing Data from Excel file - 10-08-2005 , 02:10 AM

RE: Importing Data from Excel file - 10-08-2005 , 11:58 AM