Import Problem with SQL Developer v 2.1.1.64 and Excel Files [message #510274] |
Fri, 03 June 2011 06:30 |
|
Mattes_01
Messages: 6 Registered: June 2011
|
Junior Member |
|
|
Hi there,
I hope I posted this topic in the correct forum.
Anyway, I do not have much experience with databases (with MS Excel I do) but most of the problems I have been able to resolve by myself.
I am using a TNS database.
There is one problem occuring with which you guys might help me:
I want to import data from SAP to the database, but we are having some problems with the connection and so on.
Anyway, the only way to get the data into the database is to key them in manually or to import them.
I have been using the import function (I had a lot of trouble with date formats) and it worked:
I selected the "Import Data", the corresponsing file and then have been able to see an extract of the data. It worked and I have been able to import data from an Excel file to the database.
But an error occured: Some lines have not been copied.
So I wanted to reimport them.
But from this point of time I have not been able to open any Excel file anymore:
When I select the file no extract/preview is given anymore and the file seems to be empty.
I cannot select tabs of the Excel file or anything like this.
I restarted the computer, established a new connection to the database and even reinstalled my client.
It seems that one setting has changed.
I am still able to import the data from *.csv files, but this is not as comfortable that using Excel.
Does anyone of you have an idea how to solve this problem?
Best regards from germany.
Mattes
|
|
|
Re: Import Problem with SQL Developer v 2.1.1.64 and Excel Files [message #510277 is a reply to message #510274] |
Fri, 03 June 2011 06:47 |
Roachcoach
Messages: 1576 Registered: May 2010 Location: UK
|
Senior Member |
|
|
I'm not sure exactly what you mean, however having some experience with the vagaries of importing via that tool, always select the option to send the data to a SQL worksheet. That way when a line fails to insert, you have the prepped insert statements there to work on, rather than a "black box" style import where its all or nothing.
|
|
|
Re: Import Problem with SQL Developer v 2.1.1.64 and Excel Files [message #510281 is a reply to message #510277] |
Fri, 03 June 2011 07:09 |
|
Mattes_01
Messages: 6 Registered: June 2011
|
Junior Member |
|
|
Hi Roachcoach,
I did a screenshot:
h++p://uploadpic.org/v.php?img=TVVuBSjz4G (sorry can post links yet, change "+" to "t")
In the first screen you select the xls-file.
Regardless which xls file I selected (even the xls file which used to work earlier) the next screen is the same.
Usually a preview would be given over here.
The problem wasn't that "black box style". It was neither all nor nothing.
Only a few lines haven't been imported that way, but most of the lines have been inserted.
Maybe now you have an idea what I can do.
Does anybody know where to find the settings of the "xls to sql"-converter?
This seems to be the problem for me.
By the way: -files still can be imported....
Thanks and best regards
[Updated on: Fri, 03 June 2011 07:09] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: Import Problem with SQL Developer v 2.1.1.64 and Excel Files [message #515144 is a reply to message #515141] |
Fri, 08 July 2011 04:08 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
Hi, I was on holiday when this thread was going on. You seem to have got around your issue, but one or two quick pointers on using import:
1. No passwords on the file - this is a common cause of the 'no data showing in the preview' issue.
2. no filters on the worksheet. Again, this will cause no data to show in your preview.
3. as for dates, just always remember to put the right format in when defining the columns and you should be fine.
PL
|
|
|