Hasan030800
asked on
Transfer of data from Access to Sybase
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
Hasan
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
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
ASKER
Adjusted points to 100
ASKER
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 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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. I will letb you know if there is a problem (which I do not anticipate).
The field "Memo" on Ms.Access don't function with Sybase.
Convert field Memo to Text before convert your table to Sybase.
Phil.