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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-24 : 12:02:04
|
Dave writes "I am trying to import data from MS-Excel 97 to SQL 7.0 (WinNT4 sp5) using a DTS package. The problem I'm having is that one particular column of data in the spreadsheet consists primarily of "pure" numbers, with a few alpha-numerics scattered throughout. For example:
Org Code
----------
1010453020
1010453021
1010552011
101055201A
1010553011
The DTS package automatically determines the data type of each column, which I can see using the SQL Build Query option for the Source in Data Transformation Properties. For the data as it appears above, the column is assessed as a double. If I change the first character of all the org codes to an alpha character, then the column is correctly assessed as a char field. Also, if I save the spreadsheet as a csv, it works correctly. Is there anything that I can do short of saving as a csv file? Thx,
Dave <><" |
|
|
|
|
|
DTS - Data import from MS-Excel