I have oracle 8i server with character set WE8ISO8859P1 AND CHARACTER SET IN REGEDIT IS AR8MSAWIN SOME DUMP FILES ARE EXPORTED BUT UNFORTUNALITYWIN WE TRIED TO IMPORT THESE FILES WE RECEIVED ALL TEXT FILEDS AS ?????????? I NEED YOUR HELP PLZ
SQL+ loader is a tool for Oracle database so check manual for that ,but second way its very simple start an empty access database select tables right click and select link tables then make connect to your oracle database(don't forget odbc connect in Control panel), when link tables be ready then...
Create your oracle tables as excel one,then you have two ways to solve this first save your excel data as text format then use SQl+ loader to insert your text file which you saved before.
second way user access to make a link to oracle tables then copy your excel tables and paste it on this link.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.