Difference between revisions of "Talk:MSA-Base Faq"
(→How do I import/convert my Access database to Base) |
(→How do I import/convert my Access database to Base) |
||
| Line 35: | Line 35: | ||
+ + + + + | + + + + + | ||
Dale | Dale | ||
| + | |||
| + | |||
| + | Later: this is already addressed on the FAQ(Base) page. I suppose the question now is where does it best belong? | ||
| + | |||
| + | quote | ||
| + | |||
| + | === Can I use Microsoft Access databases (.mdb) in Base? === | ||
| + | |||
| + | On Windows: yes. You cannot open them directly via <code>File|Open</code>, but you can access the data therein. For this, you need the [http://msdn.microsoft.com/data/ref/mdac/downloads Microsoft Data Access Components], which are available from Microsoft for free. (In Windows XP, they're already included, so you need them for older Windows versions only.) | ||
| + | |||
| + | Then, go to <code>File|New|Database</code>, choose "Connect to an existing datbase", and select the "Microsoft Access" database type from the list. On the next page, you then select the .mdb file you want to access - that's it! | ||
Revision as of 01:31, 28 September 2006
I edited vLookup to Dlookup. AFAIK Access does not have a vLookup function. If vLookup was intended and correct, pls change it back. Dale.
Can Base read my Access database
We seem to be missing a couple of obvious FAQs. Probably because the page has just started and they no one has got around to them yet.
Can Base read/write/open my Access database? As of version 2.0: Tables - yes. Need some instruction (sorry - I'm completely ignorant of how to do this) Queries - no (was there something about table views for Access queries?) Forms - no. Reports - no. Macros - no. Modules - no.
+ + + + + Dale.
How do I import/convert my Access database to Base
We seem to be missing a couple of obvious FAQs. Probably because the page has just started and no one has got around to them yet.
How do I import/convert my Access database to Base?
As of ver 2.0 there is no direct method for this. Tables can be read from the mdb or converted to a more Base-friendly format (native Base tables, Calc spreadsheet, csv). <<Probably need some indication of method here. Or maybe reference to a separate (yet to be written) HowTo>>
Forms and reports cannot be imported and have to be re created from scratch.
There is no direct equivalent to Access macros. These have to be re created from scratch in a language supported by OOo (StarBasic, ...)
Code modules: OOo and Base do not support VBA. The code used in you Access database will have to be rewritten in a language supported by OOo.
+ + + + + Dale
Later: this is already addressed on the FAQ(Base) page. I suppose the question now is where does it best belong?
quote
Can I use Microsoft Access databases (.mdb) in Base?
On Windows: yes. You cannot open them directly via File|Open, but you can access the data therein. For this, you need the Microsoft Data Access Components, which are available from Microsoft for free. (In Windows XP, they're already included, so you need them for older Windows versions only.)
Then, go to File|New|Database, choose "Connect to an existing datbase", and select the "Microsoft Access" database type from the list. On the next page, you then select the .mdb file you want to access - that's it!
