|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Import from Access to SQL 2000 with SQL 2005 management studioI am using the SQL 2005 management studio to import a table from an access
database to a SQl Server 2000. It's giving an error on an access column that is a memo field type and can't convert the memo to a varchar on sql 2000 and gives the unicode error. Since the instalation of the SQL 2005 management studio the Enterprise manager stopped working and it's giveing about 100 errors (dlls probably missing) so I need some urgent help because I need to upload the data! Can someone help me please. Thanks Hi,
For the time being use the SQL Server 2000 import and export wizard to load the data. In SQL 2000 use the Text data type for memo in access.. Thanks Hari SQL Server MVP Show quote "Giorgio" <Gior***@discussions.microsoft.com> wrote in message news:462CE049-793F-459C-B12A-73894730B347@microsoft.com... >I am using the SQL 2005 management studio to import a table from an access > database to a SQl Server 2000. It's giving an error on an access column > that > is a memo field type and can't convert the memo to a varchar on sql 2000 > and > gives the unicode error. > Since the instalation of the SQL 2005 management studio the Enterprise > manager stopped working and it's giveing about 100 errors (dlls probably > missing) so I need some urgent help because I need to upload the data! > Can someone help me please. > Thanks Thanks for answering me back BUT If you read my post you will see that the
Enterprise Manager stops working after installing the SQL 2005 management studio so at the moment I cannot do this! Show quote "Hari Prasad" wrote: > Hi, > > For the time being use the SQL Server 2000 import and export wizard to load > the data. In SQL 2000 use the Text data type for memo in access.. > > Thanks > Hari > SQL Server MVP > > "Giorgio" <Gior***@discussions.microsoft.com> wrote in message > news:462CE049-793F-459C-B12A-73894730B347@microsoft.com... > >I am using the SQL 2005 management studio to import a table from an access > > database to a SQl Server 2000. It's giving an error on an access column > > that > > is a memo field type and can't convert the memo to a varchar on sql 2000 > > and > > gives the unicode error. > > Since the instalation of the SQL 2005 management studio the Enterprise > > manager stopped working and it's giveing about 100 errors (dlls probably > > missing) so I need some urgent help because I need to upload the data! > > Can someone help me please. > > Thanks > > > Change the type of the column that you are importing to. Make it NTEXT.
See if that helps... Show quote "Giorgio" <Gior***@discussions.microsoft.com> wrote in message news:6B7268E2-D980-43E7-BAC9-D4531515F885@microsoft.com... > Thanks for answering me back BUT If you read my post you will see that the > Enterprise Manager stops working after installing the SQL 2005 management > studio so at the moment I cannot do this! > > > "Hari Prasad" wrote: > >> Hi, >> >> For the time being use the SQL Server 2000 import and export wizard to >> load >> the data. In SQL 2000 use the Text data type for memo in access.. >> >> Thanks >> Hari >> SQL Server MVP >> >> "Giorgio" <Gior***@discussions.microsoft.com> wrote in message >> news:462CE049-793F-459C-B12A-73894730B347@microsoft.com... >> >I am using the SQL 2005 management studio to import a table from an >> >access >> > database to a SQl Server 2000. It's giving an error on an access column >> > that >> > is a memo field type and can't convert the memo to a varchar on sql >> > 2000 >> > and >> > gives the unicode error. >> > Since the instalation of the SQL 2005 management studio the Enterprise >> > manager stopped working and it's giveing about 100 errors (dlls >> > probably >> > missing) so I need some urgent help because I need to upload the data! >> > Can someone help me please. >> > Thanks >> >> >> I can't chage it because there's an existing app running and we need a memo
field in the access db because we need to store large text. Show quote "Warren Brunk" wrote: > Change the type of the column that you are importing to. Make it NTEXT. > > See if that helps... > > -- > /* > Warren Brunk - MCITP - SQL 2005, MCDBA > www.techintsolutions.com > */ > > > "Giorgio" <Gior***@discussions.microsoft.com> wrote in message > news:6B7268E2-D980-43E7-BAC9-D4531515F885@microsoft.com... > > Thanks for answering me back BUT If you read my post you will see that the > > Enterprise Manager stops working after installing the SQL 2005 management > > studio so at the moment I cannot do this! > > > > > > "Hari Prasad" wrote: > > > >> Hi, > >> > >> For the time being use the SQL Server 2000 import and export wizard to > >> load > >> the data. In SQL 2000 use the Text data type for memo in access.. > >> > >> Thanks > >> Hari > >> SQL Server MVP > >> > >> "Giorgio" <Gior***@discussions.microsoft.com> wrote in message > >> news:462CE049-793F-459C-B12A-73894730B347@microsoft.com... > >> >I am using the SQL 2005 management studio to import a table from an > >> >access > >> > database to a SQl Server 2000. It's giving an error on an access column > >> > that > >> > is a memo field type and can't convert the memo to a varchar on sql > >> > 2000 > >> > and > >> > gives the unicode error. > >> > Since the instalation of the SQL 2005 management studio the Enterprise > >> > manager stopped working and it's giveing about 100 errors (dlls > >> > probably > >> > missing) so I need some urgent help because I need to upload the data! > >> > Can someone help me please. > >> > Thanks > >> > >> > >> > > > Dont change it in access. Change it on the SQL table that you are importing
the data to. Change it from Varchar to Ntext. Show quote "Giorgio" <Gior***@discussions.microsoft.com> wrote in message news:77937ACC-F4B5-46DD-82D5-981978BB7579@microsoft.com... >I can't chage it because there's an existing app running and we need a memo > field in the access db because we need to store large text. > > "Warren Brunk" wrote: > >> Change the type of the column that you are importing to. Make it NTEXT. >> >> See if that helps... >> >> -- >> /* >> Warren Brunk - MCITP - SQL 2005, MCDBA >> www.techintsolutions.com >> */ >> >> >> "Giorgio" <Gior***@discussions.microsoft.com> wrote in message >> news:6B7268E2-D980-43E7-BAC9-D4531515F885@microsoft.com... >> > Thanks for answering me back BUT If you read my post you will see that >> > the >> > Enterprise Manager stops working after installing the SQL 2005 >> > management >> > studio so at the moment I cannot do this! >> > >> > >> > "Hari Prasad" wrote: >> > >> >> Hi, >> >> >> >> For the time being use the SQL Server 2000 import and export wizard to >> >> load >> >> the data. In SQL 2000 use the Text data type for memo in access.. >> >> >> >> Thanks >> >> Hari >> >> SQL Server MVP >> >> >> >> "Giorgio" <Gior***@discussions.microsoft.com> wrote in message >> >> news:462CE049-793F-459C-B12A-73894730B347@microsoft.com... >> >> >I am using the SQL 2005 management studio to import a table from an >> >> >access >> >> > database to a SQl Server 2000. It's giving an error on an access >> >> > column >> >> > that >> >> > is a memo field type and can't convert the memo to a varchar on sql >> >> > 2000 >> >> > and >> >> > gives the unicode error. >> >> > Since the instalation of the SQL 2005 management studio the >> >> > Enterprise >> >> > manager stopped working and it's giveing about 100 errors (dlls >> >> > probably >> >> > missing) so I need some urgent help because I need to upload the >> >> > data! >> >> > Can someone help me please. >> >> > Thanks >> >> >> >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics