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 |
|
pcride
Starting Member
9 Posts |
 Posted - 2009-08-01 : 15:15:51
|
Please see screen shot. THis prevents the excel sheet data to be imported into the data base. |
|
|
pcride
Starting Member
9 Posts |
Posted - 2009-08-01 : 15:27:26
|
| After I import the data the colums are there but NO data. Why didn't the data import? I could see the data on the import wizard preview. |
 |
|
|
pcride
Starting Member
9 Posts |
Posted - 2009-08-01 : 15:50:10
|
It appears it was my data. The fields have more than 255 char. when setting these to MAX, it didn't appear to fix it. I deleted all the large fields and was able to import.Seems that there is a restriction on the data that can be imported into SQL |
|
|
|
|
|
|
Error when importing data via SQL 2008 Import wiza