[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Transfer of data from Access to Sybase

Posted on 2000-03-08
6
Medium Priority
?
260 Views
Last Modified: 2008-03-10
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
0
Comment
Question by:Hasan030800
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 

Expert Comment

by:samphi
ID: 2597170
Humm, I'm not sure that:

The field "Memo" on Ms.Access don't function with Sybase.
Convert field Memo to Text before convert your table to Sybase.

Phil.
0
 
LVL 9

Expert Comment

by:david_levine
ID: 2598592
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
0
 

Author Comment

by:Hasan030800
ID: 2600391
Adjusted points to 100
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:Hasan030800
ID: 2600392
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
0
 
LVL 9

Accepted Solution

by:
david_levine earned 400 total points
ID: 2600604
In Access, open the table you want to get into Sybase and click on File / Export. In the window that opens select the location and the name of the exported file and select Text Files in the Save As Type list and then click Save All. Another window will open. Verify that Delimited is checked at the top and click Next. Change the delimiter to Tab and the Text Qualifier to {None}. Click next, verify the location of the file and click the Finish button. You now have a tab-separated file.

In Sybase, create an exact copy of the Access table but use the appropriate Sybase datatypes. Once the table is created, from a DOS command prompt, type something like the following:

bcp db_name..table_name in x:\subdir\flat_file.tab -c -Uuserid -Ppassword -Sserver_name

where db_name is your Sybase database, table_name is the table you created to load the data into, x:\subdir\flat_file.tab is the path and file-name of the exported Access flat file, userid & password are your Sybase id & password and server_name is the Sybase server you are connecting to.

Let me know if you run into any snags.

David
0
 

Author Comment

by:Hasan030800
ID: 2600621
Thank you. I will letb you know if there is a problem (which I do not anticipate).
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A walk-through example of how to obtain and apply new DID phone numbers to your cloud PBX enabled users that are configured in Office 365. Whether you have 1, 10 or 100+ users in your tenant, it's quite easy to get them phone-enabled and making/rece…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question