Import Excel Sheet to SQL Server 2000

M

MadhavRao

Hi All,

I am facing strange problem importing Excel file to SQL Server using DTS.
Certain cells which are having numeric values are not getting imported. I
mean they appear as "Null" values on importing to SQL Server.
If I add "'" in front of this numeric values it gets imported.
Can anyone explain me whats going wrong and how can it be overcomed without
changing Excel File. I mean I do not wish to do any modification to Excel
file but still inport it to SQL Server.

Thanks & Regards
MadhavRao
 
J

Jamie Collins

...
I am facing strange problem importing Excel file to SQL Server using DTS.
Certain cells which are having numeric values are not getting imported. I
mean they appear as "Null" values on importing to SQL Server.
If I add "'" in front of this numeric values it gets imported.
Can anyone explain me whats going wrong and how can it be overcomed without
changing Excel File.
Click to expand...

For an explanation of the causes of and possible solutions to this issue, see:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
A

aaron.kempf

excel isn't reliable.

throw it out the window; format your machiens and install office
wihtout excel

it is the only answer

this kindof stuff isn't as reliable or powerful-- the root of the
problem is that excel is misused every day by millions of users.

use access for data entry.

teach your beancounters to write sql queries
 
K

Ken Wright

Another fictitious reply to a non-existent post just to get a rant into the
newsgroups - Petty beyond belief.
 
Top