Oracle 10g Express. Invalid table name?

Question

I've tried to load data using two methods: Text file with tab delimiter and copy paste from spreadsheet. Every time it says failed because of invalid table name. I've tried over and over but its no use. There's no problem when I manually insert rows into the table through the object browser. FYI the table name i've given is C_DETAILS........ Is there anything I can do apart from get frustrated?!

Answer 1

How are you loading the data? When going from an excel file to Oracle, I often create a delimited text file using the "|" (pipe) symbol as the delimiter character. I then build a file suitable for the sqlldr command and haven't run into any problems.