Re: Import from Access to SQL 2000 with SQL 2005 management studio
- From: "Hari Prasad" <hari_prasad_k@xxxxxxxxxxx>
- Date: Wed, 13 Sep 2006 06:40:33 -0500
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" <Giorgio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:462CE049-793F-459C-B12A-73894730B347@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: SQL Profiler - logging to table
- Next by Date: Re: Import from Access to SQL 2000 with SQL 2005 management studio
- Previous by thread: Re: Backup(s) using SQL Enterprise Manager
- Next by thread: Re: Import from Access to SQL 2000 with SQL 2005 management studio
- Index(es):
Relevant Pages
|
