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 |
|
jerill
Starting Member
7 Posts |
 Posted - 2011-10-25 : 14:26:59
|
| Hi,I am fron end as Access 2003 form and back end as SQL Server 2008 R2. I am trying to import text file using Access 2003 form.But I get error message : "You tried to assign the NULL value to a variable that is not a variant data type"Any idea why I am getting this error message. It started once I upgraded my database from Access 2003 to SQL Servr 2008 . It use to work absolutely fine in Access 2003. Any idea ?Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-10-25 : 15:00:24
|
| And check if your target table has an identity column - for which you probably have to remove whatever code attempts to populate it.Be One with the OptimizerTG |
 |
|
|
|
|
|
You tried to assign the NULL value to a variable t