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.
| Author |
Topic |
|
brett_king
Starting Member
2 Posts |
 Posted - 2005-07-04 : 12:06:20
|
| Howdy all, I have seen this error before but can't find the relevant fix.I am importing a field from Excel to SQL2000 via DTS. Most of the records in the field are numeric but there are some that are alphanumeric, even though I have my database field set to varchar it does not import the alpha characters.Can you help?Thanks, Brett |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-04 : 15:01:02
|
| Here's a workaround that might help: Try placing an alphanumeric value in the first row of EXCEL and try again. |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-07-05 : 04:19:53
|
quote:
Originally posted by SamC
Here's a workaround that might help: Try placing an alphanumeric value in the first row of EXCEL and try again.
Hi,Did you fix your problem? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2005-07-05 : 05:11:21
|
| This is the error I get.Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Unspecified error]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
DTS Excel import excluding alpha-numeric values