<div>
Humm, I'm not sure that:<br />
<br />
The field &quot;Memo&quot; on Ms.Access don't function with Sybase.<br />
Convert field Memo to Text before convert your table to Sybase.<br />
<br />
Phil.
</div>


<div>
Do you need to just do this once or is this an ongoing need?<br />
<br />
You can export the table data in Access to a tab delimited flat-file (column separator = Tab and Sting Deliminter = {None}.<br />
<br />
The use the Sybase BCP program to load the data. <br />
<br />
If this solution sounds viable I can give specifics on each step if you need assistance.<br />
<br />
David
</div>


<div>
David,<br />
Thank you very much for your response. It is a one time thing and I would greatly sppreciate if you could give me some specifics on the steps. Thank you
</div>


<div>
Thank you. I will letb you know if there is a problem (which I do not anticipate).
</div>


<div>
<div class="content wysiwyg-content">
I just wanted a summary of the steps involved in transferring data from an access database to sybase database. Are there certain issues that one has to be aware of? I am looking for problems, or concern that may arise from this conversion. Thank you,<br />
Hasan
</div>
</div>


I just wanted a summary of the steps involved in transferring data from an access database to sybase database. Are there certain issues that one has to be aware of? I am looking for problems, or concern that may arise from this conversion. Thank you,
Hasan

Humm, I&#39;m not sure that:

The field &quot;Memo&quot; on Ms.Access don&#39;t function with Sybase.
Convert field Memo to Text before convert your table to Sybase.

Phil.

Do you need to just do this once or is this an ongoing need?

You can export the table data in Access to a tab delimited flat-file (column separator = Tab and Sting Deliminter = {None}.

The use the Sybase BCP program to load the data. 

If this solution sounds viable I can give specifics on each step if you need assistance.

David

David,
Thank you very much for your response. It is a one time thing and I would greatly sppreciate if you could give me some specifics on the steps. Thank you

Thank you. I will letb you know if there is a problem (which I do not anticipate).

Transfer of data from Access to Sybase

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.