March 17, 2010 at 2:56 am
we want to generate .mdb-Files from content of DB-Tables. Using Jet 4.0 Provider, there are many Errors " cannot convert between unicode and non-unicode string data types", but we haven´t make any defintion yet.
what´s wrong ? is there another possibility?
Thanks in avance for you support
March 17, 2010 at 3:15 am
Does the Access file already exist? It needs to, or you won't be able to set up your mappings.
Do you really need many files, or just many tables within one file?
Your errors suggest that the field datatype in Access is Unicode and in SQL Server it is not, or vice versa.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 17, 2010 at 3:32 am
Phil Parkin (3/17/2010)
Does the Access file already exist? It needs to, or you won't be able to set up your mappings. (1)Do you really need many files, or just many tables within one file? (2)
Your errors suggest that the field datatype in Access is Unicode and in SQL Server it is not, or vice versa. (3)
thx for your quick answer ...
(1) no the mdb-File does not exist, but its funny because i only want to generate it with the structure from DB-Table - and there is no way to do that (or i can´t see it)
(2) No only one file from one table - by now
(3) yes unfortunately - i tested the "Data Conversion" and it helped me, but almost every of the 50 columns have to be changed to unicode string [DT_WStr] - thats stupid ! many absurd work
again many thanks, i think i do it manually , but i´ll be glad to hear from some alternatives !!!!
March 17, 2010 at 3:47 am
The SQL Server Export Wizard might generate the relevant Access CREATE TABLE commands for you (I haven't used it for a long time, so I'm not sure). You could edit these commands to avoid all the data conversion tasks ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 17, 2010 at 3:55 am
Phil Parkin (3/17/2010)
The SQL Server Export Wizard might generate the relevant Access CREATE TABLE commands for you (I haven't used it for a long time, so I'm not sure). You could edit these commands to avoid all the data conversion tasks ...
i tried it as well, but with the same errors ....
and by the way a nice picture of you 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply