Access-oracle exporting..

Results 1 to 2 of 2

Thread: Access-oracle exporting..

  1. #1
    mythili Guest

    Default Access-oracle exporting..

    Hi all,<BR>How do I export database from access to oracle?<BR>I have tried Export of Access to ODBC databases.<BR>But it gives a message "Record too large"<BR><BR>I have also tried writing this query in c++ appli.<BR>"INSERT INTO &#060;table&#062; SELECT * FROM &#060;table&#062; IN "c:\ path"<BR>but the odbc error message says Coomand not properly ended!!<BR><BR>Can some one tell me what the problem is?<BR>Or some one knows how to export data from acc-oracle<BR><BR>thanks <BR>mythili

  2. #2
    Join Date
    Dec 1969

    Default RE: Access-oracle exporting..

    If you have SQL Server 7 EM, you can create a package and "pump" the date between the two db&#039s.<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts