Import Excel Sheet to SQL Server 2000

  • Thread starter Thread starter MadhavRao
  • Start date Start date
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
 
...
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.

--
 
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
 
Another fictitious reply to a non-existent post just to get a rant into the
newsgroups - Petty beyond belief.
 
Back
Top