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 |
|
dboiler1
Starting Member
39 Posts |
 Posted - 2007-09-03 : 12:21:39
|
| I have several dbs I export to Access each month and have not had this problem before. When I try exporting now, I get the message "cannot convert between unicode and non-unicode string data types". I know I can change the data type from varchar to nvarchar to correct this but there are dozens and dozens of tables in these dbs and changing all of them is not an option. Any suggestions first to how to accomplish the export and second why this is suddenly happening. I run SQL Server 2005 Standard and keep my updates current on my OS's and applications.Thanks,Dave |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 12:54:57
|
| Anyone modified data type in access recently? |
 |
|
|
dboiler1
Starting Member
39 Posts |
Posted - 2007-09-03 : 13:10:02
|
| These are newly created Access dbs. They are blank. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 13:14:56
|
| Double checked data type? |
|
|
|
dboiler1
Starting Member
39 Posts |
Posted - 2007-09-03 : 13:50:56
|
| The Access db's are blank until i export the tables from SQL to them. But I cannot export any tables because of that error. Therefore I cannot open an Access table in design view if there are no tables to open. Thanks for your replies rmiao, but any other ideas? |
|
|
|
|
|
|
Exporting to Access