problem in importing data from excel to sql
i am facing problem while importing data. from excel to ms sql.
the problem is such that in column password suppose the data is (abc, abc123,123),i am able to import data in combination of (abc,abc123) or (123,abc123) . the first cell in password column is alphnumeric ie abc123. in sql i am able to import alpahbetic and alphanumeric characters but not numeric characters from excel .
i am using oledb connection
one error i found was unable to find isam drivers .when defineng connection string (.....;mixed =yes") in excel connection string
using odbc too iam findfing the same error
bydefault winxp supports mdac and in .net too u need not use mdac drivers.please suggest me the solution to abopve problem