Excel Inserts Null Values in DTS package
- From: "Inna" <mednyk@xxxxxxxxxxx>
- Date: 14 Sep 2006 09:49:59 -0700
Hello all,
I have DTS package that is importing data from multiple large Excel
files from same directory
into 1 database table. The structures are same and sizes of the .xls
files are good.
The problems come after all files are successfully imported.
The problem:
All contents are formatted as General.
I have 2 types of values in same column
First scenario:
1 cell :899990
2 cell :899990AB
When I import it to database
1 cell is imported as 899990
2 cell is imported as NULL
Second scenario:
1 cell :899990AB
2 cell :899990
When I import it to database
1 cell is imported as 899990AB
2 cell is imported as NULL
I understood that If the first cell is number Excel assumes that all
others are numbers as well and vice versa.
We wrote macro that would go to each cell add empty space and format it
as text and does it for each file on the given directory. It worked
fine, but
for 23 files, 599999 lines each it took 10 days for this macro to run
and I need it to be done at least for 2 days.
I tried to add Extended property in Excel Connection to Disconnected
edit
IMEX=1 it works only for the first file, and others are still having
the problems
Is there any other way to fix this problem.
Thank you in advance
.
- Prev by Date: Re: SQL Server training
- Next by Date: Re: Newbie Question on DB Maintenance Plan
- Previous by thread: Newbie Question on DB Maintenance Plan
- Next by thread: sql 2005 client tools
- Index(es):
Relevant Pages
|
