Importing Memo Fields into Text Fields

[ctarr]

I have an Access97 database with twenty text fields and two memo fields in one table. I am upgrading this system to SQL 2k and am attempting to use the import wizard. However, everytime I run the Import/Export wizard I get an error that the data in row one exceeded the buffer. If I filter the fields to only allow those with 1000 or fewer characters to be imported it works. I do this via creating a Query in Access that only returns records with that number of characters or less in the memo field. In the Import wizard I call this query by writing,

 select workdescription, id from descriptionview

This returns the smaller recordset and it works great. But, how about the other 50,000+ records that have much more data.

I've read the KB articles and many other posts about Excel importing issues with SQL 2k. Are there issues with memo fields in Access as well?

The largest record in either memo field is around 9000 characters. So, it's not a space issue in SQL. Should I switch the field in Access to text (breaking up the records over 1000 characters), should I use the Access upsize wizard. Or should I use bcp?

Thanks for any suggestions, Craig