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 |
|
Chainwhip
Starting Member
33 Posts |
 Posted - 2004-08-30 : 16:54:11
|
| HiI am having a problem importing a spreadhseet into an SQL table using the "Import Data" wizard in SQL manager. One of the columns in the spreadsheet has text values some of which are over 255 characters and the wizard is telling me the buffer size is not big enough to do the import because of this. Any ideas?Thanks in advanceCW |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-30 : 16:55:44
|
| Do not have the import wizard create the table for you. If you do, it creates the columns as varchar(255). So first manually create the table. Then import the data into this new existing table.Tara |
 |
|
|
Chainwhip
Starting Member
33 Posts |
Posted - 2004-08-30 : 17:18:42
|
| I've already tried this but the same error happens "Data source for [column] is too large for the specified buffer size". It seems ok when the data is below 255 characters but anything above this throws the error. |
|
|
|
Chainwhip
Starting Member
33 Posts |
Posted - 2004-08-30 : 17:33:39
|
| Not like me to answer my own question! In case anyone else comes across this problem the workaround is to save the excel sheet as a tab-separated text file then import this into the SQL instead. Works a treat! |
|
|
|
Mike2265
Starting Member
6 Posts |
Posted - 2004-08-31 : 06:20:25
|
| Or as a .csv file - that's what I usually use and I've never had any problems. Though now I find it easiest to do it using the import functionality in an Access .adp - for one off imports at least.cheers,Mike |
|
|
|
|
|
|
import data from excel spreadsheet