Problem in import/Export from Access to MSSQL2000

tejal_k_mehta

Hi,

I have created one application using VB-MSSQL 2000.
in this application facility to export the data from SQL to Access has been given.Also it has faclity to import from Access to SQL.

In the database one of the table is containing the field which stores the binary data.
for that Binary data
in SQL field type is ntext
in Access Field type is memo.

Now when i try to import from Access to SQL,binary data gets courrpted and give me wrong result.

Is this problem b'coze of datatype in SQL and access are different.

pls help me regarding this.

-Regards

rirajat

i never face this problem so i m not very sure but i think it will be better if u transfar ur access data in to txt/binary file and then try to transfar into sql

: Hi,
:
: I have created one application using VB-MSSQL 2000.
: in this application facility to export the data from SQL to Access has been given.Also it has faclity to import from Access to SQL.
:
: In the database one of the table is containing the field which stores the binary data.
: for that Binary data
: in SQL field type is ntext
: in Access Field type is memo.
:
: Now when i try to import from Access to SQL,binary data gets courrpted and give me wrong result.
:
: Is this problem b'coze of datatype in SQL and access are different.
:
: pls help me regarding this.
:
: -Regards
:
: