Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Import Excel using distributed queries

Author  Topic 

surya_madhavi
Starting Member

1 Post

Posted - 2005-03-03 : 10:35:15
Hi all

I am using Distributed Queries with oledb to export data from excel to sql server. The data is updated successfully but i found in one particular column the values are updated as null.

The column is of manufacturerno which has alphanumeric values. If values is alphanumeric it is updating successfully if the value is only numeric it is updating null values.



Can anyone help me


   

- Advertisement -