Interesting. It was a bug in excel corrected by upgrading to the latest
service pack. I don't usually run Excel on the DB server so I did not even
think about it. I will have to be more diligent about getting the service
packs on every machine.
A real major bug I would say in the original XP Office that it can't do that
import and get the data right.
on 12/10/03 21:33, Dan Stein at [EMAIL PROTECTED] wrote:
> One thing I see that the version I was using of excel on this machine was
> not the latest update it is two version behind so maybe that it it.
>
> Any thoughts?
>
> on 12/10/03 21:29, Dan Stein at [EMAIL PROTECTED] wrote:
>
>> This was an interesting 4 or 5 hours.
>>
>> Windows 2000 Advanced Server Latest Service Pack
>>
>> MS SQL 200 SP3
>> Filemaker V6.-4
>> Excel 2000 10.2614.2625
>>
>>
>>
>> After doing a major data cleaning of a table using Filemaker I exported the
>> data ( this bug happened no matter what kind of export was used even from a
>> data query directly to Excel)
>>
>> Anyway I opened the exported file in excel on windows 2000 Excel 200 latest
>> updates etc.
>>
>> I could see that the data looked fine.
>>
>> The data has about 20 columns and 14,000 rows.
>>
>> I import the data was imported without error.
>>
>> But when I search the data about 5,000 rows fail to import values from at
>> least two of the columns. In the import transformation everything matches up
>> fine so it is not that.
>>
>> But I can see from the primary key that the value in the excel table row is
>> there but not in the SQL database.
>>
>> All the other values are right so it is not as case of the data getting
>> scrambled.
>>
>> I tried every which way to import this always with the same result.
>>
>> Finally in desperation I used a direct import from the FMP database ( which
>> I built by opening up the excel spreadsheet with Filemaker and it does the
>> conversion).
>>
>> Using the FMP ODBC driver I ran the import and it while slower was perfect.
>>
>> So there is a bug somewhere. Anybody else run into this?
>>
>> Windows 2000 Advanced Server Latest Service Pack
>>
>> MS SQL 200 SP3
>> Filemaker V6.-4
>> Excel 2000 10.2614.2625
>>
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
"When you are born, you cry and those who love you rejoice. And if you
live your life as you should, when you die, you rejoice and those who
love you cry."
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
