TXLandman wrote:I can get the thing open but once it's open I don't know what I'm looking at. It doesn't help that I haven't ever used Base or Access but I'm generally pretty good at figuring these things out.
scarles wrote:This is how I was able to import data only (no forms, queries, etc.) using Windows XP (your experience may vary).
scarles wrote:I have know idea what will happen if you have a lot of formulas or weird/extensive formatting in your original database
A database does not store formattings.
You should definitively try the self-reporting tool in Access.
Arineckaig wrote:For some reason that I do not understand this method of dragging an Access table into Calc is more tolerant of certain data types in Access that are rejected when directly copied and pasted from a Base/Access connection to Base embedded HSQL.
If you could describe which data do import correctly into Calc but don't import into HSQLDB
rbturnbull wrote:I got the same error -Value too long in statement [names of fields] VALUES (?,?,?,?,?,?,?)] while trying to drag a table from
an Access DB.
I found the problem was caused by a Boolean field (Yes/No) being incorrectly converted to a Text field.
When I corrected it in the Type Formatting screen of the wizard, it worked fine
MarcvanWegberg wrote:For me this instruction worked, mostly. Of the 503 records in one of these databases, 499 records successfully made the conversion. What happened to the other 4 I don't know.
Users browsing this forum: No registered users and 6 guests