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 |
|
chwanhun
Starting Member
22 Posts |
 Posted - 2008-10-03 : 09:43:59
|
| Hello,I have an excel spreadsheet with 15 columns. I'm using the Import/Export Wizard to import this spreasheet as a table in my SQL Server 2000 database. The import complete succesfully, however there is one column where the data doesn't import. All other data imports without issue. The format of the column is General and am importing it into a varchar field. I have tried changing the format to text and number, with no luck. Does anyone have any ideas?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 10:10:06
|
| is it first or last column? can you look into transformations and see if its mapped correctly? Also does destination table have enough size to hold data? |
 |
|
|
|
|
|
Data from Excel Spreadsheet Importing As NULL