Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing Data from Microsoft Access or Excel

483920Jan 19 2006 — edited Oct 4 2006
I am having quite a bit of difficulty importing data that is stored in Microsoft Access. I have read the manuals, checked the built in help features of OracleXE and searched these forums here for answers.

I am trying to import data from a file into a table I have already setup (although it does not yet have actual records in it). When attempting to import data using the Load feature, I can easily see all of my data and assign it to the correct columns. After hitting the load button to finish loading all the data, it goes to the repository screen showing that all the records failed to load due to ORA-00926. This error states that when using a select statement, it expects a VALUES key afterwards that is missing. This is a built in function of OracleXE and I do not understand why this would be missing.

All the documentation about the database clearly states that it should easily be able to import comma delimited, tab delimited text files, as well as easily importing xml or copying and pasting excel cells into the form/table. I am only importing a single table also.

I have tried to import into a current table I have setup in OracleXE as well as creating a new table during import using all of the following methods:
1) comma delimited .csv
2) tab delimited
3) XML
4) copying and pasting the excel cells
5) importing a .xls file

I have even contact a person at Oracle who cannot figure it out either. There were absolutely no problems with the installation, nor do any of the problems I am having have to deal with the other import bug based off the language setting of the browser or database.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2006
Added on Jan 19 2006
16 comments
758 views