Hello,
Kind of run into a weird issue. I am trying to create some saved imports for some users to import excel spreadsheets into a table. The setup is MS SQL 2008 backend with Access 2007 frontend. So on the backend the field is a varchar(MAX) and on the frontend access displays it as Memo. One particuliar row has that field filled in with around 10,000 characters. When I try the import every row makes it in except for that one. After cutting the field down to 7,930 it went in just fine. So I deleted it all and reimported again this time without the problematic 10,000 char result. Then I went into the backend and added the 10,000 char result to the correct row with no problems and even Access shows it just fine. Any idea why Access is limiting my imports to 8,000 char?
Thanks,


Shaun