| View previous topic :: View next topic |
| Author |
Message |
swingkyd
OOo Advocate
Joined: 15 Sep 2004
Posts: 479
|
 Posted: Thu May 10, 2012 8:35 pm Post subject: Spreadsheet source file column fixed as VARCHAR |
 |
|
I have a database with a Calc spreadsheet as its source. All the data in the column is a NUMBER (i made sure of this by copying data as "VALUE(#)" and pasted as a number to the whole column.
In Base, I go to "edit" the table and this column continues to come up as a Text [VARCHAR] instead of a "DECIMAL" or the likes.
Any idea why this would be happening? |
|
| Back to top |
|
 |
swingkyd
OOo Advocate
Joined: 15 Sep 2004
Posts: 479
|
| Posted: Fri May 11, 2012 11:12 am Post subject: |
|
|
| restarting OO.org including the quick started reset the database link. So it worked then! |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri May 11, 2012 12:06 pm Post subject: |
|
|
Spreadsheets are the worst type of data source. Save the spreadsheet as dBase.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
